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_ARCHIVE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 80: ***13-Feb-09 mdubasi 115.50 7590936 Replaced secure view hr_organization_units with hr_all_organization_units

76: ***26-Feb-08 vdabgar 115.47 6839263 Modified proc spawn_archive_reports,csr_params and csr_report_params cursors
77: *** to call the concurrent programs accordingly.
78: ***18-Mar-08 avenkatk 115.48 6839263 Backed out changes from assignment_action_code, initialization_code
79: ***21-Mar-08 avenkatk 115.49 6839263 Added Logic to set the OPP Template options for PDF output
80: ***13-Feb-09 mdubasi 115.50 7590936 Replaced secure view hr_organization_units with hr_all_organization_units
81: *** in the cursor c_employee_details
82: ***11-Dec-09 dduvvuri 115.51 9113084 Added RANGE_PERSON_ID for Payroll Reconciliation Detail Report
83: ***22-Dec-09 dduvvuri 115.52 9113084 Restructured the logic in assignment_action_code to use all Range
84: *** Cursors at one place and Old cursors at one place for code clarity

Line 91: g_business_group_id hr_all_organization_units.organization_id%type;

87: *** ------------------------------------------------------------------------+
88: */
89:
90: g_arc_payroll_action_id pay_payroll_actions.payroll_action_id%type;
91: g_business_group_id hr_all_organization_units.organization_id%type;
92: g_prev_assignment_id number;
93: g_def_bal_populted varchar2(1);
94:
95: g_debug boolean ;

Line 402: ,c_business_group_id hr_all_organization_units.organization_id%type

398: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
399: ,c_start_person per_all_people_f.person_id%type
400: ,c_end_person per_all_people_f.person_id%type
401: ,c_employee_type per_all_people_f.current_employee_flag%type
402: ,c_business_group_id hr_all_organization_units.organization_id%type
403: ,c_organization_id hr_all_organization_units.organization_id%type
404: ,c_archive_start_date date
405: ,c_archive_end_date date
406: ) is

Line 403: ,c_organization_id hr_all_organization_units.organization_id%type

399: ,c_start_person per_all_people_f.person_id%type
400: ,c_end_person per_all_people_f.person_id%type
401: ,c_employee_type per_all_people_f.current_employee_flag%type
402: ,c_business_group_id hr_all_organization_units.organization_id%type
403: ,c_organization_id hr_all_organization_units.organization_id%type
404: ,c_archive_start_date date
405: ,c_archive_end_date date
406: ) is
407: select paa.assignment_action_id,

Line 454: ,c_business_group_id hr_all_organization_units.organization_id%type

450: cursor rg_csr_assignment_org_period
451: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
452: ,c_chunk number
453: ,c_employee_type per_all_people_f.current_employee_flag%type
454: ,c_business_group_id hr_all_organization_units.organization_id%type
455: ,c_organization_id hr_all_organization_units.organization_id%type
456: ,c_archive_start_date date
457: ,c_archive_end_date date
458: ) is

Line 455: ,c_organization_id hr_all_organization_units.organization_id%type

451: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
452: ,c_chunk number
453: ,c_employee_type per_all_people_f.current_employee_flag%type
454: ,c_business_group_id hr_all_organization_units.organization_id%type
455: ,c_organization_id hr_all_organization_units.organization_id%type
456: ,c_archive_start_date date
457: ,c_archive_end_date date
458: ) is
459: select paa.assignment_action_id,

Line 509: ,c_business_group_id hr_all_organization_units.organization_id%type

505: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
506: ,c_start_person per_all_people_f.person_id%type
507: ,c_end_person per_all_people_f.person_id%type
508: ,c_employee_type per_all_people_f.current_employee_flag%type
509: ,c_business_group_id hr_all_organization_units.organization_id%type
510: ,c_organization_id hr_all_organization_units.organization_id%type
511: ,c_period_end_date date
512: ,c_pact_id pay_payroll_actions.payroll_action_id%type
513: ) is

Line 510: ,c_organization_id hr_all_organization_units.organization_id%type

506: ,c_start_person per_all_people_f.person_id%type
507: ,c_end_person per_all_people_f.person_id%type
508: ,c_employee_type per_all_people_f.current_employee_flag%type
509: ,c_business_group_id hr_all_organization_units.organization_id%type
510: ,c_organization_id hr_all_organization_units.organization_id%type
511: ,c_period_end_date date
512: ,c_pact_id pay_payroll_actions.payroll_action_id%type
513: ) is
514: select paa.assignment_action_id,

Line 556: ,c_business_group_id hr_all_organization_units.organization_id%type

552: cursor rg_csr_assignment_org_run
553: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
554: ,c_chunk number
555: ,c_employee_type per_all_people_f.current_employee_flag%type
556: ,c_business_group_id hr_all_organization_units.organization_id%type
557: ,c_organization_id hr_all_organization_units.organization_id%type
558: ,c_period_end_date date
559: ,c_pact_id pay_payroll_actions.payroll_action_id%type
560: ) is

Line 557: ,c_organization_id hr_all_organization_units.organization_id%type

553: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
554: ,c_chunk number
555: ,c_employee_type per_all_people_f.current_employee_flag%type
556: ,c_business_group_id hr_all_organization_units.organization_id%type
557: ,c_organization_id hr_all_organization_units.organization_id%type
558: ,c_period_end_date date
559: ,c_pact_id pay_payroll_actions.payroll_action_id%type
560: ) is
561: select paa.assignment_action_id,

Line 606: ,c_business_group_id hr_all_organization_units.organization_id%type

602: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
603: ,c_start_person per_all_people_f.person_id%type
604: ,c_end_person per_all_people_f.person_id%type
605: ,c_employee_type per_all_people_f.current_employee_flag%type
606: ,c_business_group_id hr_all_organization_units.organization_id%type
607: ,c_legal_employer hr_all_organization_units.organization_id%type
608: ,c_archive_start_date date
609: ,c_archive_end_date date
610: ) is

Line 607: ,c_legal_employer hr_all_organization_units.organization_id%type

603: ,c_start_person per_all_people_f.person_id%type
604: ,c_end_person per_all_people_f.person_id%type
605: ,c_employee_type per_all_people_f.current_employee_flag%type
606: ,c_business_group_id hr_all_organization_units.organization_id%type
607: ,c_legal_employer hr_all_organization_units.organization_id%type
608: ,c_archive_start_date date
609: ,c_archive_end_date date
610: ) is
611: select paa.assignment_action_id,

Line 656: ,c_business_group_id hr_all_organization_units.organization_id%type

652: cursor rg_csr_assignment_legal_period
653: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
654: ,c_chunk number
655: ,c_employee_type per_all_people_f.current_employee_flag%type
656: ,c_business_group_id hr_all_organization_units.organization_id%type
657: ,c_legal_employer hr_all_organization_units.organization_id%type
658: ,c_archive_start_date date
659: ,c_archive_end_date date
660: ) is

Line 657: ,c_legal_employer hr_all_organization_units.organization_id%type

653: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
654: ,c_chunk number
655: ,c_employee_type per_all_people_f.current_employee_flag%type
656: ,c_business_group_id hr_all_organization_units.organization_id%type
657: ,c_legal_employer hr_all_organization_units.organization_id%type
658: ,c_archive_start_date date
659: ,c_archive_end_date date
660: ) is
661: select paa.assignment_action_id,

Line 708: ,c_business_group_id hr_all_organization_units.organization_id%type

704: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
705: ,c_start_person per_all_people_f.person_id%type
706: ,c_end_person per_all_people_f.person_id%type
707: ,c_employee_type per_all_people_f.current_employee_flag%type
708: ,c_business_group_id hr_all_organization_units.organization_id%type
709: ,c_legal_employer hr_all_organization_units.organization_id%type
710: ,c_period_end_date date
711: ,c_pact_id pay_payroll_actions.payroll_action_id%type
712: ) is

Line 709: ,c_legal_employer hr_all_organization_units.organization_id%type

705: ,c_start_person per_all_people_f.person_id%type
706: ,c_end_person per_all_people_f.person_id%type
707: ,c_employee_type per_all_people_f.current_employee_flag%type
708: ,c_business_group_id hr_all_organization_units.organization_id%type
709: ,c_legal_employer hr_all_organization_units.organization_id%type
710: ,c_period_end_date date
711: ,c_pact_id pay_payroll_actions.payroll_action_id%type
712: ) is
713: select paa.assignment_action_id,

Line 753: ,c_business_group_id hr_all_organization_units.organization_id%type

749: cursor rg_csr_assignment_legal_run
750: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
751: , c_chunk number
752: ,c_employee_type per_all_people_f.current_employee_flag%type
753: ,c_business_group_id hr_all_organization_units.organization_id%type
754: ,c_legal_employer hr_all_organization_units.organization_id%type
755: ,c_period_end_date date
756: ,c_pact_id pay_payroll_actions.payroll_action_id%type
757: ) is

Line 754: ,c_legal_employer hr_all_organization_units.organization_id%type

750: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
751: , c_chunk number
752: ,c_employee_type per_all_people_f.current_employee_flag%type
753: ,c_business_group_id hr_all_organization_units.organization_id%type
754: ,c_legal_employer hr_all_organization_units.organization_id%type
755: ,c_period_end_date date
756: ,c_pact_id pay_payroll_actions.payroll_action_id%type
757: ) is
758: select paa.assignment_action_id,

Line 800: ,c_business_group_id hr_all_organization_units.organization_id%type

796: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
797: ,c_start_person per_all_people_f.person_id%type
798: ,c_end_person per_all_people_f.person_id%type
799: ,c_employee_type per_all_people_f.current_employee_flag%type
800: ,c_business_group_id hr_all_organization_units.organization_id%type
801: ,c_payroll_id pay_payroll_actions.payroll_id%type
802: ,c_archive_start_date date
803: ,c_archive_end_date date
804: ) is

Line 852: ,c_business_group_id hr_all_organization_units.organization_id%type

848: cursor rg_assignment_payroll_period
849: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
850: ,c_chunk NUMBER
851: ,c_employee_type per_all_people_f.current_employee_flag%type
852: ,c_business_group_id hr_all_organization_units.organization_id%type
853: ,c_payroll_id pay_payroll_actions.payroll_id%type
854: ,c_archive_start_date date
855: ,c_archive_end_date date
856: ) is

Line 905: ,c_business_group_id hr_all_organization_units.organization_id%type

901: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
902: ,c_start_person per_all_people_f.person_id%type
903: ,c_end_person per_all_people_f.person_id%type
904: ,c_employee_type per_all_people_f.current_employee_flag%type
905: ,c_business_group_id hr_all_organization_units.organization_id%type
906: ,c_payroll_id pay_payroll_actions.payroll_id%type
907: ,c_period_end_date date
908: ,c_pact_id pay_payroll_actions.payroll_action_id%type
909: ) is

Line 951: ,c_business_group_id hr_all_organization_units.organization_id%type

947: cursor rg_csr_assignment_payroll_run
948: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
949: , c_chunk NUMBER
950: ,c_employee_type per_all_people_f.current_employee_flag%type
951: ,c_business_group_id hr_all_organization_units.organization_id%type
952: ,c_payroll_id pay_payroll_actions.payroll_id%type
953: ,c_period_end_date date
954: ,c_pact_id pay_payroll_actions.payroll_action_id%type
955: ) is

Line 999: ,c_business_group_id hr_all_organization_units.organization_id%type

995: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
996: ,c_start_person per_all_people_f.person_id%type
997: ,c_end_person per_all_people_f.person_id%type
998: ,c_employee_type per_all_people_f.current_employee_flag%type
999: ,c_business_group_id hr_all_organization_units.organization_id%type
1000: ,c_assignment_id per_all_assignments_f.assignment_id%type
1001: ,c_archive_start_date date
1002: ,c_archive_end_date date
1003: ) is

Line 1048: ,c_business_group_id hr_all_organization_units.organization_id%type

1044: cursor rg_csr_assignment_period
1045: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1046: ,c_chunk NUMBER
1047: ,c_employee_type per_all_people_f.current_employee_flag%type
1048: ,c_business_group_id hr_all_organization_units.organization_id%type
1049: ,c_assignment_id per_all_assignments_f.assignment_id%type
1050: ,c_archive_start_date date
1051: ,c_archive_end_date date
1052: ) is

Line 1099: ,c_business_group_id hr_all_organization_units.organization_id%type

1095: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1096: ,c_start_person per_all_people_f.person_id%type
1097: ,c_end_person per_all_people_f.person_id%type
1098: ,c_employee_type per_all_people_f.current_employee_flag%type
1099: ,c_business_group_id hr_all_organization_units.organization_id%type
1100: ,c_assignment_id per_all_assignments_f.assignment_id%type
1101: ,c_period_end_date date
1102: ,c_pact_id pay_payroll_actions.payroll_action_id%type
1103: ) is

Line 1143: ,c_business_group_id hr_all_organization_units.organization_id%type

1139: cursor rg_csr_assignment_run
1140: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1141: , c_chunk NUMBER
1142: ,c_employee_type per_all_people_f.current_employee_flag%type
1143: ,c_business_group_id hr_all_organization_units.organization_id%type
1144: ,c_assignment_id per_all_assignments_f.assignment_id%type
1145: ,c_period_end_date date
1146: ,c_pact_id pay_payroll_actions.payroll_action_id%type
1147: ) is

Line 1190: ,c_business_group_id hr_all_organization_units.organization_id%type

1186: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1187: ,c_start_person per_all_people_f.person_id%type
1188: ,c_end_person per_all_people_f.person_id%type
1189: ,c_employee_type per_all_people_f.current_employee_flag%type
1190: ,c_business_group_id hr_all_organization_units.organization_id%type
1191: ,c_archive_start_date date
1192: ,c_archive_end_date date
1193: ) is
1194: select paa.assignment_action_id,

Line 1237: ,c_business_group_id hr_all_organization_units.organization_id%type

1233: cursor rg_assignment_default_period
1234: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1235: ,c_chunk NUMBER
1236: ,c_employee_type per_all_people_f.current_employee_flag%type
1237: ,c_business_group_id hr_all_organization_units.organization_id%type
1238: ,c_archive_start_date date
1239: ,c_archive_end_date date
1240: ) is
1241: select paa.assignment_action_id,

Line 1286: ,c_business_group_id hr_all_organization_units.organization_id%type

1282: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1283: ,c_start_person per_all_people_f.person_id%type
1284: ,c_end_person per_all_people_f.person_id%type
1285: ,c_employee_type per_all_people_f.current_employee_flag%type
1286: ,c_business_group_id hr_all_organization_units.organization_id%type
1287: ,c_period_end_date date
1288: ,c_pact_id pay_payroll_actions.payroll_action_id%type
1289: ) is
1290: select paa.assignment_action_id,

Line 1329: ,c_business_group_id hr_all_organization_units.organization_id%type

1325: cursor rg_csr_assignment_default_run
1326: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1327: , c_chunk NUMBER
1328: ,c_employee_type per_all_people_f.current_employee_flag%type
1329: ,c_business_group_id hr_all_organization_units.organization_id%type
1330: ,c_period_end_date date
1331: ,c_pact_id pay_payroll_actions.payroll_action_id%type
1332: ) is
1333: select paa.assignment_action_id,

Line 2750: cursor c_employee_details(c_business_group_id hr_all_organization_units.organization_id%TYPE,

2746: ) is
2747:
2748:
2749:
2750: cursor c_employee_details(c_business_group_id hr_all_organization_units.organization_id%TYPE,
2751: c_assignment_id number,c_end_date date, c_start_date date) /*Bug#3662449 c_start_date parameter added*/
2752: is
2753: select pap.full_name,
2754: paa.assignment_number,

Line 2774: hr_all_organization_units hou, /Bug 3953706 /

2770: per_pay_bases ppb,
2771: per_pay_proposals pro,
2772: per_assignment_status_types past,
2773: hr_soft_coding_keyflex hsc, /*Bug 4040688*/
2774: hr_all_organization_units hou, /*Bug 3953706 */
2775: hr_all_organization_units hou1 /*Bug 4132525*/
2776: -- pay_payrolls_f papf /*Bug 4132525, Bug 4688872*/
2777: where pap.person_id = paa.person_id
2778: and paa.assignment_id = c_assignment_id

Line 2775: hr_all_organization_units hou1 /Bug 4132525/

2771: per_pay_proposals pro,
2772: per_assignment_status_types past,
2773: hr_soft_coding_keyflex hsc, /*Bug 4040688*/
2774: hr_all_organization_units hou, /*Bug 3953706 */
2775: hr_all_organization_units hou1 /*Bug 4132525*/
2776: -- pay_payrolls_f papf /*Bug 4132525, Bug 4688872*/
2777: where pap.person_id = paa.person_id
2778: and paa.assignment_id = c_assignment_id
2779: and paa.business_group_id = c_business_group_id

Line 2855: cursor c_element_details(c_business_group_id hr_all_organization_units.organization_id%TYPE,c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

2851: */
2852:
2853:
2854:
2855: cursor c_element_details(c_business_group_id hr_all_organization_units.organization_id%TYPE,c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
2856: is
2857: select element_name,label classification_name,sum(amount) payment,sum(hours) hours,source_action_id master_action_id, tax_unit_id master_tax_unit_id,rate /*Bug 3935471 ,5461557 */
2858: from
2859: (select distinct -- Bug No: 4045910