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

Line 11: g_business_group_id hr_all_organization_units.organization_id%type;

7: /* Bug 4036052
8: Initalize variables for Archive model -- Start */
9:
10: g_arc_payroll_action_id pay_payroll_actions.payroll_action_id%type;
11: g_business_group_id hr_all_organization_units.organization_id%type;
12: g_prev_assignment_id number;
13: g_def_bal_populted varchar2(1);
14:
15: g_end_date date;

Line 516: ,c_business_group_id hr_all_organization_units.organization_id%type

512: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
513: ,c_start_person per_all_people_f.person_id%type
514: ,c_end_person per_all_people_f.person_id%type
515: ,c_employee_type per_all_people_f.current_employee_flag%type
516: ,c_business_group_id hr_all_organization_units.organization_id%type
517: ,c_organization_id hr_all_organization_units.organization_id%type
518: ,c_archive_start_date date
519: ,c_archive_end_date date
520: ) is

Line 517: ,c_organization_id hr_all_organization_units.organization_id%type

513: ,c_start_person per_all_people_f.person_id%type
514: ,c_end_person per_all_people_f.person_id%type
515: ,c_employee_type per_all_people_f.current_employee_flag%type
516: ,c_business_group_id hr_all_organization_units.organization_id%type
517: ,c_organization_id hr_all_organization_units.organization_id%type
518: ,c_archive_start_date date
519: ,c_archive_end_date date
520: ) is
521: select paa.assignment_action_id,

Line 569: ,c_business_group_id hr_all_organization_units.organization_id%type

565: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
566: ,c_start_person per_all_people_f.person_id%type
567: ,c_end_person per_all_people_f.person_id%type
568: ,c_employee_type per_all_people_f.current_employee_flag%type
569: ,c_business_group_id hr_all_organization_units.organization_id%type
570: ,c_organization_id hr_all_organization_units.organization_id%type
571: ,c_period_end_date date
572: ,c_pact_id pay_payroll_actions.payroll_action_id%type
573: ) is

Line 570: ,c_organization_id hr_all_organization_units.organization_id%type

566: ,c_start_person per_all_people_f.person_id%type
567: ,c_end_person per_all_people_f.person_id%type
568: ,c_employee_type per_all_people_f.current_employee_flag%type
569: ,c_business_group_id hr_all_organization_units.organization_id%type
570: ,c_organization_id hr_all_organization_units.organization_id%type
571: ,c_period_end_date date
572: ,c_pact_id pay_payroll_actions.payroll_action_id%type
573: ) is
574: select paa.assignment_action_id,

Line 620: ,c_business_group_id hr_all_organization_units.organization_id%type

616: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
617: ,c_start_person per_all_people_f.person_id%type
618: ,c_end_person per_all_people_f.person_id%type
619: ,c_employee_type per_all_people_f.current_employee_flag%type
620: ,c_business_group_id hr_all_organization_units.organization_id%type
621: ,c_legal_employer hr_all_organization_units.organization_id%type
622: ,c_archive_start_date date
623: ,c_archive_end_date date
624: ) is

Line 621: ,c_legal_employer hr_all_organization_units.organization_id%type

617: ,c_start_person per_all_people_f.person_id%type
618: ,c_end_person per_all_people_f.person_id%type
619: ,c_employee_type per_all_people_f.current_employee_flag%type
620: ,c_business_group_id hr_all_organization_units.organization_id%type
621: ,c_legal_employer hr_all_organization_units.organization_id%type
622: ,c_archive_start_date date
623: ,c_archive_end_date date
624: ) is
625: select paa.assignment_action_id,

Line 679: ,c_business_group_id hr_all_organization_units.organization_id%type

675: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
676: ,c_start_person per_all_people_f.person_id%type
677: ,c_end_person per_all_people_f.person_id%type
678: ,c_employee_type per_all_people_f.current_employee_flag%type
679: ,c_business_group_id hr_all_organization_units.organization_id%type
680: ,c_legal_employer hr_all_organization_units.organization_id%type
681: ,c_period_end_date date
682: ,c_pact_id pay_payroll_actions.payroll_action_id%type
683: ) is

Line 680: ,c_legal_employer hr_all_organization_units.organization_id%type

676: ,c_start_person per_all_people_f.person_id%type
677: ,c_end_person per_all_people_f.person_id%type
678: ,c_employee_type per_all_people_f.current_employee_flag%type
679: ,c_business_group_id hr_all_organization_units.organization_id%type
680: ,c_legal_employer hr_all_organization_units.organization_id%type
681: ,c_period_end_date date
682: ,c_pact_id pay_payroll_actions.payroll_action_id%type
683: ) is
684: select paa.assignment_action_id,

Line 730: ,c_business_group_id hr_all_organization_units.organization_id%type

726: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
727: ,c_start_person per_all_people_f.person_id%type
728: ,c_end_person per_all_people_f.person_id%type
729: ,c_employee_type per_all_people_f.current_employee_flag%type
730: ,c_business_group_id hr_all_organization_units.organization_id%type
731: ,c_payroll_id pay_payroll_actions.payroll_id%type
732: ,c_archive_start_date date
733: ,c_archive_end_date date
734: ) is

Line 780: ,c_business_group_id hr_all_organization_units.organization_id%type

776: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
777: ,c_start_person per_all_people_f.person_id%type
778: ,c_end_person per_all_people_f.person_id%type
779: ,c_employee_type per_all_people_f.current_employee_flag%type
780: ,c_business_group_id hr_all_organization_units.organization_id%type
781: ,c_payroll_id pay_payroll_actions.payroll_id%type
782: ,c_period_end_date date
783: ,c_pact_id pay_payroll_actions.payroll_action_id%type
784: ) is

Line 826: ,c_business_group_id hr_all_organization_units.organization_id%type

822: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
823: ,c_start_person per_all_people_f.person_id%type
824: ,c_end_person per_all_people_f.person_id%type
825: ,c_employee_type per_all_people_f.current_employee_flag%type
826: ,c_business_group_id hr_all_organization_units.organization_id%type
827: ,c_assignment_id per_all_assignments_f.assignment_id%type
828: ,c_archive_start_date date
829: ,c_archive_end_date date
830: ) is

Line 875: ,c_business_group_id hr_all_organization_units.organization_id%type

871: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
872: ,c_start_person per_all_people_f.person_id%type
873: ,c_end_person per_all_people_f.person_id%type
874: ,c_employee_type per_all_people_f.current_employee_flag%type
875: ,c_business_group_id hr_all_organization_units.organization_id%type
876: ,c_assignment_id per_all_assignments_f.assignment_id%type
877: ,c_period_end_date date
878: ,c_pact_id pay_payroll_actions.payroll_action_id%type
879: ) is

Line 920: ,c_business_group_id hr_all_organization_units.organization_id%type

916: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
917: ,c_start_person per_all_people_f.person_id%type
918: ,c_end_person per_all_people_f.person_id%type
919: ,c_employee_type per_all_people_f.current_employee_flag%type
920: ,c_business_group_id hr_all_organization_units.organization_id%type
921: ,c_archive_start_date date
922: ,c_archive_end_date date
923: ) is
924: select paa.assignment_action_id,

Line 967: ,c_business_group_id hr_all_organization_units.organization_id%type

963: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
964: ,c_start_person per_all_people_f.person_id%type
965: ,c_end_person per_all_people_f.person_id%type
966: ,c_employee_type per_all_people_f.current_employee_flag%type
967: ,c_business_group_id hr_all_organization_units.organization_id%type
968: ,c_period_end_date date
969: ,c_pact_id pay_payroll_actions.payroll_action_id%type
970: ) is
971: select paa.assignment_action_id,

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

1744: Cursor c_employee_details - Added join with table per_grades_tl to fetch and archive the grade name.
1745: Outer Join introduced between per_grades_tl and per_assignments_f based on grade_id.
1746: */
1747:
1748: cursor c_employee_details(c_business_group_id hr_all_organization_units.organization_id%TYPE,
1749: c_assignment_id number,c_end_date date, c_start_date date) /*Bug#3662449 c_start_date parameter added*/
1750: is
1751: select pap.full_name,
1752: paa.assignment_number,