[Home] [Help]
169: l_ret boolean;
170:
171: cursor csr_check_action(l_mode1 varchar2, l_mode2 varchar2) is
172: select 1
173: from pay_payroll_actions pay,
174: pay_assignment_actions paa
175: where (pay.report_type like l_mode1
176: or
177: pay.report_type like l_mode2) -- Bug 6770200.
284: select to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id,
285: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
286: effective_date,
287: business_group_id
288: from pay_payroll_actions
289: where payroll_action_id = pactid;
290:
291: cursor csr_asg is
292: select asg.assignment_id
330: cursor csr_p46_5_def_det(p_assignment_id number,default_archive varchar2)
331: is
332: select 1
333: from pay_action_information pa
334: ,pay_payroll_actions ppa
335: ,pay_assignment_actions paa
336: where pa.action_information_category in 'GB P46_5 EDI'
337: and pa.action_context_type = 'AAP'
338: and pa.action_information4 = default_archive
342: and ppa.action_status = 'C';
343:
344: cursor csr_p46_5_def_assact(p_assignment_id number) is
345: select act.assignment_action_id
346: from pay_payroll_actions pact,
347: pay_assignment_actions act
348: where pact.report_type = 'P46_5'
349: and pact.action_status ='C'
350: and pact.report_qualifier = 'GB'
638: -- there, then it was going for element entry values.
639: /*
640: cursor csr_max_run_result(p_element_id number) is
641: select /*+ ORDERED INDEX (assact2 PAY_ASSIGNMENT_ACTIONS_N51,
642: pact PAY_PAYROLL_ACTIONS_PK,
643: r2 PAY_RUN_RESULTS_N50)
644: USE_NL(assact2, pact, r2) */
645: /* to_number(substr(max(lpad(assact2.action_sequence,15,'0')||r2.source_type|| r2.run_result_id),17))
646: from pay_assignment_actions assact2,
643: r2 PAY_RUN_RESULTS_N50)
644: USE_NL(assact2, pact, r2) */
645: /* to_number(substr(max(lpad(assact2.action_sequence,15,'0')||r2.source_type|| r2.run_result_id),17))
646: from pay_assignment_actions assact2,
647: pay_payroll_actions pact,
648: pay_run_results r2
649: where assact2.assignment_id = l_assignment_id
650: and r2.element_type_id+0 = p_element_id
651: and r2.assignment_action_id = assact2.assignment_action_id
657: and not exists(
658: select '1'
659: from pay_action_interlocks pai,
660: pay_assignment_actions assact3,
661: pay_payroll_actions pact3
662: where pai.locked_action_id = assact2.assignment_action_id
663: and pai.locking_action_id = assact3.assignment_action_id
664: and pact3.payroll_action_id = assact3.payroll_action_id
665: and pact3.action_type = 'V'
1275: cursor csr_p46_5_def_det
1276: is
1277: select 1
1278: from pay_action_information pa
1279: ,pay_payroll_actions ppa
1280: ,pay_assignment_actions paa
1281: where pa.action_information_category = 'GB P46_5 EDI'
1282: and pa.action_context_type = 'AAP'
1283: and pa.action_information4 = 'Y'
1505: upper(hoi.org_information1),
1506: upper(hoi.org_information2),
1507: upper(hoi.org_information3),
1508: upper(hoi.org_information4)
1509: from pay_payroll_actions pact,
1510: hr_organization_information hoi
1511: where pact.payroll_action_id = p_payroll_action_id
1512: and pact.business_group_id = hoi.organization_id
1513: and hoi.org_information_context = 'Tax Details References'
1576: 'TEST'),1,1) test_indicator,
1577: trim(substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1578: 'TEST_ID'),1,8)) test_id,
1579: report_type
1580: FROM pay_payroll_actions
1581: WHERE payroll_action_id = pactid;
1582:
1583:
1584: l_test_indicator varchar2(1);
1604: /* Changes for P45PT3 end*/
1605:
1606: sqlstr := 'select distinct person_id '||
1607: 'from per_people_f ppf, '||
1608: 'pay_payroll_actions ppa '||
1609: 'where ppa.payroll_action_id = :payroll_action_id '||
1610: 'and ppa.business_group_id = ppf.business_group_id '||
1611: 'order by ppf.person_id';
1612: hr_utility.trace(' Range Cursor Statement : '||sqlstr);
1691:
1692: cursor csr_archive_type is
1693: select report_type
1694: from pay_assignment_actions paa,
1695: pay_payroll_actions ppa
1696: where paa.assignment_action_id = p_assactid
1697: and paa.payroll_action_id = ppa.payroll_action_id;
1698:
1699: BEGIN
1783: select legislative_parameters para,
1784: fnd_number.number_to_canonical(request_id) control_id,
1785: report_type,
1786: business_group_id
1787: from pay_payroll_actions
1788: where payroll_action_id = pactid;
1789:
1790: cursor csr_header_det(p_bus_id number,
1791: p_tax_ref varchar2) is
1916: peo.last_name l_name,
1917: peo.title title,
1918: paf.assignment_number emp_no,
1919: peo.national_identifier ni_no
1920: from pay_payroll_actions pay,
1921: pay_assignment_actions paa,
1922: per_all_assignments_f paf,
1923: per_all_people_f peo
1924: where pay.payroll_action_id = pactid
1976: select pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST_ID'),
1977: pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),
1978: /*ppa.effective_date*/
1979: sysdate
1980: from pay_payroll_actions ppa
1981: ,pay_assignment_actions paa
1982: where paa.assignment_action_id = c_assignment_action_id
1983: and ppa.payroll_action_id = paa.payroll_action_id;
1984: