eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on PAY_PAYROLL_ACTIONS

Line 74: g_arc_payroll_action_id pay_payroll_actions.payroll_action_id%type;

70: Based on the type of report,appropriate data is archived.
71:
72: Any changes made to this package must be Functionally/Technically tested against both reports.
73: */
74: g_arc_payroll_action_id pay_payroll_actions.payroll_action_id%type;
75: g_business_group_id hr_all_organization_units.organization_id%type;
76:
77: g_debug boolean ;
78:

Line 98: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type

94: --
95: --------------------------------------------------------------------
96:
97: procedure range_code
98: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
99: ,p_sql out NOCOPY varchar2
100: ) is
101:
102: l_procedure varchar2(200) ;

Line 117: ' pay_payroll_actions pa' ||

113: -- Archive the payroll action level data and EIT defintions.
114: -- sql string to SELECT a range of assignments eligible for archival.
115: p_sql := ' select distinct p.person_id' ||
116: ' from per_people_f p,' ||
117: ' pay_payroll_actions pa' ||
118: ' where pa.payroll_action_id = :payroll_action_id' ||
119: ' and p.business_group_id = pa.business_group_id' ||
120: ' order by p.person_id';
121:

Line 139: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)

135: --------------------------------------------------------------------
136:
137:
138: procedure initialization_code
139: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)
140: is
141:
142: CURSOR csr_defined_balance_id
143: IS

Line 182: from pay_payroll_actions

178: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') fbt_year_end_date
179: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_year_term
180: ,pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug 4142159*/
181: ,decode(pay_core_utils.get_parameter('REP_MODE',legislative_parameters),'SUMM','S','D') report_mode /*Bug 3891577*/
182: from pay_payroll_actions
183: where payroll_action_id = c_payroll_action_id;
184:
185: Cursor c_fbt_balance is
186: select pdb.defined_balance_id

Line 404: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type

400: -- it then archives Payroll Run assignment action id details
401: --------------------------------------------------------------------+
402:
403: procedure assignment_action_code
404: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
405: ,p_start_person in per_all_people_f.person_id%type
406: ,p_end_person in per_all_people_f.person_id%type
407: ,p_chunk in number
408: ) is

Line 423: from pay_payroll_actions

419: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') fbt_year_end_date
420: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_year_term
421: ,pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug 4142159*/
422: ,decode(pay_core_utils.get_parameter('REP_MODE',legislative_parameters),'SUMM','S','D') report_mode /*Bug 3891577*/
423: from pay_payroll_actions
424: where payroll_action_id = c_payroll_action_id;
425:
426: --------------------------------------------------------------------+
427: -- Cursor : csr_assignment_paysum

Line 433: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type

429: -- Returns DISTINCT assignment_id
430: --
431: --------------------------------------------------------------------+
432: cursor csr_assignment_paysum
433: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
434: ,c_start_person per_all_people_f.person_id%type
435: ,c_end_person per_all_people_f.person_id%type
436: ,c_employee_type per_all_people_f.current_employee_flag%type
437: ,c_business_group_id hr_all_organization_units.organization_id%type

Line 452: INDEX(rppa pay_payroll_actions_pk)

448: ) is
449: SELECT /*+ INDEX(pap per_people_f_pk)
450: INDEX(paa per_assignments_f_fk1)
451: INDEX(paa per_assignments_f_N12)
452: INDEX(rppa pay_payroll_actions_pk)
453: INDEX(pps per_periods_of_service_n3)
454: */ distinct paa.assignment_id
455: from per_people_f pap
456: ,per_assignments_f paa

Line 457: ,pay_payroll_actions rppa

453: INDEX(pps per_periods_of_service_n3)
454: */ distinct paa.assignment_id
455: from per_people_f pap
456: ,per_assignments_f paa
457: ,pay_payroll_actions rppa
458: ,per_periods_of_service pps
459: where rppa.payroll_action_id = c_payroll_action_id
460: and pap.person_id between c_start_person and c_end_person
461: and pap.person_id = paa.person_id

Line 479: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)

475: and paa.payroll_id like c_payroll_id
476: and paa.assignment_id like c_assignment_id
477: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
478: INDEX(rpac pay_assignment_actions_n1)
479: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
480: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''
481: FROM per_assignments_f paaf
482: ,pay_payroll_actions rppa
483: ,pay_assignment_actions rpac

Line 480: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''

476: and paa.assignment_id like c_assignment_id
477: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
478: INDEX(rpac pay_assignment_actions_n1)
479: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
480: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''
481: FROM per_assignments_f paaf
482: ,pay_payroll_actions rppa
483: ,pay_assignment_actions rpac
484: where (rppa.effective_date between c_fin_year_start and c_fin_year_end /*Bug3048962 */

Line 482: ,pay_payroll_actions rppa

478: INDEX(rpac pay_assignment_actions_n1)
479: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
480: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''
481: FROM per_assignments_f paaf
482: ,pay_payroll_actions rppa
483: ,pay_assignment_actions rpac
484: where (rppa.effective_date between c_fin_year_start and c_fin_year_end /*Bug3048962 */
485: or ( pps.actual_termination_date between c_lst_fbt_yr_start and c_fbt_year_end /*Bug3263659 */
486: and rppa.effective_date between c_fbt_year_start and c_fbt_year_end

Line 507: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type

503: -- Assignment.
504: --------------------------------------------------------------------+
505:
506: cursor csr_assignment_only_paysum
507: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
508: ,c_start_person per_all_people_f.person_id%type
509: ,c_end_person per_all_people_f.person_id%type
510: ,c_employee_type per_all_people_f.current_employee_flag%type
511: ,c_business_group_id hr_all_organization_units.organization_id%type

Line 526: INDEX(rppa pay_payroll_actions_pk)

522: ) is
523: SELECT /*+ INDEX(pap per_people_f_pk)
524: INDEX(paa per_assignments_f_fk1)
525: INDEX(paa per_assignments_f_N12)
526: INDEX(rppa pay_payroll_actions_pk)
527: INDEX(pps per_periods_of_service_n3)
528: */ distinct paa.assignment_id
529: from per_people_f pap
530: ,per_assignments_f paa

Line 531: ,pay_payroll_actions rppa

527: INDEX(pps per_periods_of_service_n3)
528: */ distinct paa.assignment_id
529: from per_people_f pap
530: ,per_assignments_f paa
531: ,pay_payroll_actions rppa
532: ,per_periods_of_service pps
533: where rppa.payroll_action_id = c_payroll_action_id
534: and pap.person_id between c_start_person and c_end_person
535: and pap.person_id = paa.person_id

Line 553: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)

549: and paa.payroll_id like c_payroll_id
550: and paa.assignment_id = c_assignment_id
551: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
552: INDEX(rpac pay_assignment_actions_n1)
553: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
554: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''
555: FROM per_assignments_f paaf
556: ,pay_payroll_actions rppa
557: ,pay_assignment_actions rpac

Line 554: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''

550: and paa.assignment_id = c_assignment_id
551: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
552: INDEX(rpac pay_assignment_actions_n1)
553: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
554: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''
555: FROM per_assignments_f paaf
556: ,pay_payroll_actions rppa
557: ,pay_assignment_actions rpac
558: where (rppa.effective_date between c_fin_year_start and c_fin_year_end /*Bug3048962 */

Line 556: ,pay_payroll_actions rppa

552: INDEX(rpac pay_assignment_actions_n1)
553: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
554: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''
555: FROM per_assignments_f paaf
556: ,pay_payroll_actions rppa
557: ,pay_assignment_actions rpac
558: where (rppa.effective_date between c_fin_year_start and c_fin_year_end /*Bug3048962 */
559: or ( pps.actual_termination_date between c_lst_fbt_yr_start and c_fbt_year_end /*Bug3263659 */
560: and rppa.effective_date between c_fbt_year_start and c_fbt_year_end

Line 585: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type

581: --------------------------------------------------------------------+
582: */
583:
584: CURSOR csr_range_assignment_paysum
585: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
586: ,c_chunk NUMBER
587: ,c_employee_type per_all_people_f.current_employee_flag%type
588: ,c_business_group_id hr_all_organization_units.organization_id%type
589: ,c_legal_employer pay_assignment_actions.tax_unit_id%type

Line 602: INDEX(rppa pay_payroll_actions_pk)

598: ,c_assignment_id varchar2
599: )
600: IS
601: SELECT /*+ INDEX(pap per_people_f_pk)
602: INDEX(rppa pay_payroll_actions_pk)
603: INDEX(ppr PAY_POPULATION_RANGES_N4)
604: INDEX(paa per_assignments_f_N12)
605: INDEX(pps per_periods_of_service_PK)
606: */ paa.assignment_id

Line 609: ,pay_payroll_actions rppa

605: INDEX(pps per_periods_of_service_PK)
606: */ paa.assignment_id
607: from per_people_f pap
608: ,per_assignments_f paa
609: ,pay_payroll_actions rppa
610: ,per_periods_of_service pps
611: ,pay_population_ranges ppr
612: WHERE rppa.payroll_action_id = c_payroll_action_id
613: AND rppa.payroll_action_id = ppr.payroll_action_id

Line 632: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)

628: AND iipaf.payroll_id IS NOT NULL) /*Bug 4688800*/
629: AND paa.payroll_id like c_payroll_id
630: AND paa.assignment_id like c_assignment_id
631: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
632: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
633: */''
634: FROM per_assignments_f paaf
635: ,pay_payroll_actions rppa
636: ,pay_assignment_actions rpac

Line 635: ,pay_payroll_actions rppa

631: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
632: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
633: */''
634: FROM per_assignments_f paaf
635: ,pay_payroll_actions rppa
636: ,pay_assignment_actions rpac
637: WHERE (rppa.effective_date between c_fin_year_start AND c_fin_year_end /*Bug3048962 */
638: or ( pps.actual_termination_date between c_lst_fbt_yr_start AND c_fbt_year_end /*Bug3263659 */
639: AND rppa.effective_date between c_fbt_year_start AND c_fbt_year_end

Line 890: ,p_effective_date in pay_payroll_actions.effective_date%type

886: --------------------------------------------------------------------+
887:
888: procedure archive_code
889: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
890: ,p_effective_date in pay_payroll_actions.effective_date%type
891: )
892: is
893:
894: --------------------------------------------------------------------+

Line 1029: , pay_payroll_actions ppa

1025: is
1026: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
1027: ,max(paa.action_sequence) action_sequence
1028: from pay_assignment_actions paa
1029: , pay_payroll_actions ppa
1030: , per_assignments_f paf
1031: where paa.assignment_id = paf.assignment_id
1032: and paf.assignment_id = c_assignment_id
1033: and ppa.payroll_action_id = paa.payroll_action_id

Line 1411: , pay_payroll_actions ppa

1407: IS
1408: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
1409: ,max(paa.action_sequence) action_sequence
1410: from pay_assignment_actions paa
1411: , pay_payroll_actions ppa
1412: , per_assignments_f paf
1413: where paa.assignment_id = paf.assignment_id
1414: and paf.assignment_id = c_assignment_id
1415: and ppa.payroll_action_id = paa.payroll_action_id

Line 1562: ,pay_payroll_actions ppa

1558: from pay_element_types_f pet
1559: ,pay_input_values_f piv1
1560: ,pay_element_classifications pec
1561: ,pay_assignment_actions paa
1562: ,pay_payroll_actions ppa
1563: ,per_assignments_f paaf
1564: ,pay_run_results prr
1565: ,pay_run_result_values prrv1
1566: ,pay_element_classifications pec2

Line 1872: pay_payroll_Actions ppa,

1868: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%type )
1869: IS
1870: select max(paa.assignment_action_id) assignment_action_id
1871: from per_assignments_f paf,
1872: pay_payroll_Actions ppa,
1873: pay_assignment_Actions paa,
1874: per_time_periods ptp
1875: where ppa.payroll_Action_id = paa.payroll_Action_id
1876: and paa.assignment_id = c_assignment_id

Line 2257: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)

2253:
2254: --------------------------------------------------------------------+
2255:
2256: procedure spawn_archive_reports
2257: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)
2258: is
2259: l_count number;
2260: ps_request_id NUMBER;
2261: l_print_style VARCHAR2(2);

Line 2273: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)

2269: -- Description : Fetches User Parameters from Legislative_paramters
2270: -- column.
2271: --------------------------------------------------------------------+
2272:
2273: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
2274: IS
2275: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) business_group_id
2276: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) legal_employer
2277: ,pay_core_utils.get_parameter('PAYROLL',legislative_parameters) payroll_id

Line 2288: from pay_payroll_actions

2284: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_year_term
2285: ,pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug 4142159*/
2286: ,decode(pay_core_utils.get_parameter('REP_MODE',legislative_parameters),'SUMM','S','D') report_mode /* Bug 3891577*/
2287: ,pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters)p_output_type
2288: from pay_payroll_actions
2289: where payroll_action_id = c_payroll_action_id;
2290:
2291:
2292: cursor csr_get_print_options(p_payroll_action_id NUMBER) IS

Line 2297: FROM pay_payroll_actions pact,

2293: SELECT printer,
2294: print_style,
2295: decode(save_output_flag, 'Y', 'TRUE', 'N', 'FALSE') save_output
2296: ,number_of_copies /* Bug 4116833 */
2297: FROM pay_payroll_actions pact,
2298: fnd_concurrent_requests fcr
2299: WHERE fcr.request_id = pact.request_id
2300: AND pact.payroll_action_id = p_payroll_action_id;
2301:

Line 2467: ,pay_payroll_actions ppa

2463: IS
2464: SELECT DISTINCT pet.element_information2 balance_type_id
2465: FROM pay_element_types_f pet
2466: ,per_all_assignments_f paf
2467: ,pay_payroll_actions ppa
2468: ,pay_assignment_actions paa
2469: ,pay_run_results prr
2470: WHERE ppa.effective_date BETWEEN c_start_date AND c_end_date
2471: AND ppa.action_type in ('R','Q','B','V','I')

Line 2517: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)

2513:
2514: end summary_rep_populate_allowance;
2515:
2516: procedure spawn_summary_reports
2517: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)
2518: is
2519: l_count number;
2520: ps_request_id NUMBER;
2521: l_print_style VARCHAR2(2);

Line 2532: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)

2528: -- Description : Fetches User Parameters from Legislative_paramters
2529: -- column.
2530: --------------------------------------------------------------------+
2531:
2532: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
2533: IS
2534: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) business_group_id
2535: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) legal_employer
2536: ,pay_core_utils.get_parameter('PAYROLL',legislative_parameters) payroll_id

Line 2546: from pay_payroll_actions

2542: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') fbt_year_end_date
2543: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_year_term
2544: ,pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions
2545: ,decode(pay_core_utils.get_parameter('REP_MODE',legislative_parameters),'SUMM','S','D') report_mode
2546: from pay_payroll_actions
2547: where payroll_action_id = c_payroll_action_id;
2548:
2549:
2550: cursor csr_get_print_options(p_payroll_action_id NUMBER) IS

Line 2555: FROM pay_payroll_actions pact,

2551: SELECT printer,
2552: print_style,
2553: decode(save_output_flag, 'Y', 'TRUE', 'N', 'FALSE') save_output
2554: ,number_of_copies
2555: FROM pay_payroll_actions pact,
2556: fnd_concurrent_requests fcr
2557: WHERE fcr.request_id = pact.request_id
2558: AND pact.payroll_action_id = p_payroll_action_id;
2559: