[Home] [Help]
204: l_ret boolean;
205:
206: cursor csr_check_action(l_mode1 varchar2, l_mode2 varchar2 , l_mode3 varchar2, l_mode4 varchar2) is --Changed for bug 9255173
207: select 1
208: from pay_payroll_actions pay,
209: pay_assignment_actions paa
210: where (pay.report_type like l_mode1
211: or
212: pay.report_type like l_mode2 -- Bug 6770200.
352: select to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id,
353: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
354: effective_date,
355: business_group_id
356: from pay_payroll_actions
357: where payroll_action_id = pactid;
358:
359: -- Bug 8574855 : Added hint PER_ASSIGNMENTS_F_N12 for tuning the query.
360: cursor csr_asg is
400: cursor csr_p46_5_def_det(p_assignment_id number,default_archive varchar2)
401: is
402: select 1
403: from pay_action_information pa
404: ,pay_payroll_actions ppa
405: ,pay_assignment_actions paa
406: where pa.action_information_category in 'GB P46_5 EDI'
407: and pa.action_context_type = 'AAP'
408: and pa.action_information4 = default_archive
412: and ppa.action_status = 'C';
413:
414: cursor csr_p46_5_def_assact(p_assignment_id number) is
415: select act.assignment_action_id
416: from pay_payroll_actions pact,
417: pay_assignment_actions act
418: where pact.report_type = p_rep_type -- Changed to handle P46_VER6 also
419: and pact.action_status ='C'
420: and pact.report_qualifier = 'GB'
828: -- there, then it was going for element entry values.
829: /*
830: cursor csr_max_run_result(p_element_id number) is
831: select /*+ ORDERED INDEX (assact2 PAY_ASSIGNMENT_ACTIONS_N51,
832: pact PAY_PAYROLL_ACTIONS_PK,
833: r2 PAY_RUN_RESULTS_N50)
834: USE_NL(assact2, pact, r2) */
835: /* to_number(substr(max(lpad(assact2.action_sequence,15,'0')||r2.source_type|| r2.run_result_id),17))
836: from pay_assignment_actions assact2,
833: r2 PAY_RUN_RESULTS_N50)
834: USE_NL(assact2, pact, r2) */
835: /* to_number(substr(max(lpad(assact2.action_sequence,15,'0')||r2.source_type|| r2.run_result_id),17))
836: from pay_assignment_actions assact2,
837: pay_payroll_actions pact,
838: pay_run_results r2
839: where assact2.assignment_id = l_assignment_id
840: and r2.element_type_id+0 = p_element_id
841: and r2.assignment_action_id = assact2.assignment_action_id
847: and not exists(
848: select '1'
849: from pay_action_interlocks pai,
850: pay_assignment_actions assact3,
851: pay_payroll_actions pact3
852: where pai.locked_action_id = assact2.assignment_action_id
853: and pai.locking_action_id = assact3.assignment_action_id
854: and pact3.payroll_action_id = assact3.payroll_action_id
855: and pact3.action_type = 'V'
1568: edi_validation_fail out nocopy varchar2) IS
1569:
1570: CURSOR get_effective_date IS
1571: SELECT ppa.effective_date
1572: FROM pay_payroll_actions ppa, pay_assignment_actions paa
1573: WHERE ppa.payroll_action_id = paa.payroll_action_id
1574: AND paa.assignment_action_id = p_assactid;
1575:
1576: l_proc CONSTANT VARCHAR2(50):= g_package||'p46exp_asg_etext_validations';
1748: and addr.action_context_type = 'AAP';
1749:
1750: Cursor get_effective_date is
1751: select ppa.effective_date
1752: from pay_payroll_actions ppa, pay_assignment_actions paa
1753: where paa.payroll_action_id = ppa.payroll_action_id
1754: and paa.assignment_action_id = p_assactid;
1755:
1756: /* Modifications end here */
2054: cursor csr_p46_5_def_det
2055: is
2056: select 1
2057: from pay_action_information pa
2058: ,pay_payroll_actions ppa
2059: ,pay_assignment_actions paa
2060: where pa.action_information_category = 'GB P46_5 EDI'
2061: and pa.action_context_type = 'AAP'
2062: and pa.action_information4 = 'Y'
2389: upper(hoi.org_information1),
2390: upper(hoi.org_information2),
2391: upper(hoi.org_information3),
2392: upper(hoi.org_information4)
2393: from pay_payroll_actions pact,
2394: hr_organization_information hoi
2395: where pact.payroll_action_id = p_payroll_action_id
2396: and pact.business_group_id = hoi.organization_id
2397: and hoi.org_information_context = 'Tax Details References'
2412: 'TEST'),1,1) test_indicator,
2413: trim(substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2414: 'TEST_ID'),1,8)) test_id,
2415: report_type
2416: FROM pay_payroll_actions
2417: WHERE payroll_action_id = p_payroll_action_id;
2418:
2419: l_tst_indi varchar2(1);
2420: l_tst_id varchar2(10);
2501: 'TEST'),1,1) test_indicator,
2502: trim(substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2503: 'TEST_ID'),1,8)) test_id,
2504: report_type
2505: FROM pay_payroll_actions
2506: WHERE payroll_action_id = pactid;
2507:
2508:
2509: l_test_indicator varchar2(1);
2534: /* Changes for P45PT3 end*/
2535:
2536: sqlstr := 'select distinct person_id '||
2537: 'from per_people_f ppf, '||
2538: 'pay_payroll_actions ppa '||
2539: 'where ppa.payroll_action_id = :payroll_action_id '||
2540: 'and ppa.business_group_id = ppf.business_group_id '||
2541: 'order by ppf.person_id';
2542: hr_utility.trace(' Range Cursor Statement : '||sqlstr);
2829:
2830: cursor csr_archive_type is
2831: select report_type
2832: from pay_assignment_actions paa,
2833: pay_payroll_actions ppa
2834: where paa.assignment_action_id = p_assactid
2835: and paa.payroll_action_id = ppa.payroll_action_id;
2836:
2837: BEGIN
3015:
3016: --For bugs 9255173 and 9255183
3017: Cursor csr_is_etext_report IS
3018: Select report_type
3019: From pay_payroll_actions pact
3020: Where pact.payroll_action_id = pactid;
3021:
3022: l_is_etext_report varchar2(50);
3023: l_request_id fnd_concurrent_requests.request_id%TYPE;
3039: select legislative_parameters para,
3040: fnd_number.number_to_canonical(request_id) control_id,
3041: report_type,
3042: business_group_id
3043: from pay_payroll_actions
3044: where payroll_action_id = pactid;
3045:
3046: cursor csr_header_det(p_bus_id number,
3047: p_tax_ref varchar2) is
3226: peo.last_name l_name,
3227: peo.title title,
3228: paf.assignment_number emp_no,
3229: peo.national_identifier ni_no
3230: from pay_payroll_actions pay,
3231: pay_assignment_actions paa,
3232: per_all_assignments_f paf,
3233: per_all_people_f peo
3234: where pay.payroll_action_id = pactid
3248: upper(peo.last_name) l_name,
3249: upper(peo.title) title,
3250: upper(paf.assignment_number) emp_no,
3251: upper(peo.national_identifier) ni_no
3252: from pay_payroll_actions pay,
3253: pay_assignment_actions paa,
3254: per_all_assignments_f paf,
3255: per_all_people_f peo
3256: where pay.payroll_action_id = pactid
3412: select pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST_ID'),
3413: pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),
3414: /*ppa.effective_date*/
3415: sysdate
3416: from pay_payroll_actions ppa
3417: ,pay_assignment_actions paa
3418: where paa.assignment_action_id = c_assignment_action_id
3419: and ppa.payroll_action_id = paa.payroll_action_id;
3420:
3421:
3422: --For bug 8704601:Added new cursor
3423: cursor csr_parameter_info_p46_car is
3424: select ppa.effective_date
3425: from pay_payroll_actions ppa
3426: ,pay_assignment_actions paa
3427: where paa.assignment_action_id = c_assignment_action_id
3428: and ppa.payroll_action_id = paa.payroll_action_id;
3429: