ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4714851A9E05362FB09050512Y select distinct paa.tax_unit_id tax_uid2, ppf.last_name || ', '|| ppf.first_name emp_name, paf.assignment_number asg_num, substr(ltrim(pea.segment4),1,8) tr_code, substr(ltrim(pea.segment4),9,1) chk_dig, pea.segment5 bank_nam, pea.segment3 acct_num, substr(hrl.meaning,1,8)||' ' acct_typ, decode(pps.value,0,'Yes','No') pnot_dat, pps.value amount , pps.pre_payment_id pre_payment_id, PAY_PAYUSNAC_XMLP_PKG.calc_pnot(pps.value) C_ADD_PRENOT from pay_pre_payments pps, pay_external_accounts pea, pay_personal_payment_methods_f ppp, per_people_f ppf, hr_lookups hrl, pay_action_interlocks int2, pay_action_interlocks int, pay_assignment_actions paa3, pay_payroll_actions ppa, per_assignments_f paf, pay_assignment_actions paa where hrl.lookup_type = 'US_ACCOUNT_TYPE' and hrl.lookup_code = pea.segment2 and ppp.external_account_id = pea.external_account_id and ppp.personal_payment_method_id = pps.personal_payment_method_id and :paid_date between ppp.effective_start_date and ppp.effective_end_date and pps.pre_payment_id = paa.pre_payment_id and ppf.person_id = paf.person_id and :paid_date between ppf.effective_start_date and ppf.effective_end_date and paf.payroll_id = :payrid and :period = hr_payrolls.display_period_name(ppa.payroll_action_id) and ppa.action_type in ('R', 'Q', 'B') and ppa.payroll_action_id = paa3.payroll_action_id and ( (pps.source_action_id is not null and paa3.assignment_action_id = pps.source_action_id) or (pps.source_action_id is null and paa3.source_action_id is null) ) and paa3.assignment_action_id = int2.locked_action_id and int2.locking_action_id = int.locked_action_id and int.locking_action_id = paa.assignment_action_id and paf.assignment_id = paa.assignment_id and :paid_date between paf.effective_start_date and paf.effective_end_date and paa.payroll_action_id = :p_payroll_action_id and paa.tax_unit_id=:tax_uid ORDER BY 1,2,3 PAY PAYRPNAC_XML US PAY NACHA Imported from BI Publisher Description: NACHA Report Application: Payroll Source: NACHA Report (XML) Short Name: PAYRPNAC_XML DB package: PAY_PAYUSNAC_XMLP_PKG BI Publisher :c_business_group_name :c_consolidation_set_id :c_payroll_action_name :p_business_group_id :p_conc_request_id :p_payroll_action_id :p_totals_only :paid_date :payrid :period :tax_uid 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US Business_group_name Business Group Name 2 10 :p_payroll_action_id LOV Oracle HR_US_MAGTAPE_ACTION Y select a.payroll_action_id id, fnd_date.date_to_chardate(a.effective_date)||'-'||to_char(a.request_id)||'-'||b.consolidation_set_name||'-'||c.payroll_name value, null description from pay_payroll_actions a,pay_consolidation_sets b,pay_all_payrolls_f c where a.consolidation_set_id=b.consolidation_set_id and a.payroll_id=c.payroll_id (+) and nvl(a.payroll_id,-999)=decode(a.payroll_id, null,-999, (select ppf.payroll_id from pay_payrolls_f ppf where ppf.payroll_id=a.payroll_id and a.effective_date between ppf.effective_start_date and ppf.effective_end_date)) and a.action_type='M' and a.action_status='C' and a.effective_date between nvl (c.effective_start_date,a.effective_date) and nvl (c.effective_end_date,a.effective_date) and a.business_group_id+0= fnd_global.per_business_group_id order by payroll_action_id desc Y US NACHA Process Payroll action Name 3 20 :p_totals_only LOV Oracle HR_US_YES_NO Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='YES_NO' order by value,description SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' and lookup_code ='N' Y US Totals Only Totals Only