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 84: g_business_group_id hr_all_organization_units.organization_id%type;

80: *** ------------------------------------------------------------------------+
81: */
82:
83: g_arc_payroll_action_id pay_payroll_actions.payroll_action_id%type;
84: g_business_group_id hr_all_organization_units.organization_id%type;
85: g_prev_assignment_id number;
86: g_def_bal_populted varchar2(1);
87:
88: g_debug boolean ;

Line 330: ,c_business_group_id hr_all_organization_units.organization_id%type

326: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
327: ,c_start_person per_all_people_f.person_id%type
328: ,c_end_person per_all_people_f.person_id%type
329: ,c_employee_type per_all_people_f.current_employee_flag%type
330: ,c_business_group_id hr_all_organization_units.organization_id%type
331: ,c_organization_id hr_all_organization_units.organization_id%type
332: ,c_archive_start_date date
333: ,c_archive_end_date date
334: ) is

Line 331: ,c_organization_id hr_all_organization_units.organization_id%type

327: ,c_start_person per_all_people_f.person_id%type
328: ,c_end_person per_all_people_f.person_id%type
329: ,c_employee_type per_all_people_f.current_employee_flag%type
330: ,c_business_group_id hr_all_organization_units.organization_id%type
331: ,c_organization_id hr_all_organization_units.organization_id%type
332: ,c_archive_start_date date
333: ,c_archive_end_date date
334: ) is
335: select paa.assignment_action_id,

Line 383: ,c_business_group_id hr_all_organization_units.organization_id%type

379: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
380: ,c_start_person per_all_people_f.person_id%type
381: ,c_end_person per_all_people_f.person_id%type
382: ,c_employee_type per_all_people_f.current_employee_flag%type
383: ,c_business_group_id hr_all_organization_units.organization_id%type
384: ,c_organization_id hr_all_organization_units.organization_id%type
385: ,c_period_end_date date
386: ,c_pact_id pay_payroll_actions.payroll_action_id%type
387: ) is

Line 384: ,c_organization_id hr_all_organization_units.organization_id%type

380: ,c_start_person per_all_people_f.person_id%type
381: ,c_end_person per_all_people_f.person_id%type
382: ,c_employee_type per_all_people_f.current_employee_flag%type
383: ,c_business_group_id hr_all_organization_units.organization_id%type
384: ,c_organization_id hr_all_organization_units.organization_id%type
385: ,c_period_end_date date
386: ,c_pact_id pay_payroll_actions.payroll_action_id%type
387: ) is
388: select paa.assignment_action_id,

Line 430: ,c_business_group_id hr_all_organization_units.organization_id%type

426: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
427: ,c_start_person per_all_people_f.person_id%type
428: ,c_end_person per_all_people_f.person_id%type
429: ,c_employee_type per_all_people_f.current_employee_flag%type
430: ,c_business_group_id hr_all_organization_units.organization_id%type
431: ,c_legal_employer hr_all_organization_units.organization_id%type
432: ,c_archive_start_date date
433: ,c_archive_end_date date
434: ) is

Line 431: ,c_legal_employer hr_all_organization_units.organization_id%type

427: ,c_start_person per_all_people_f.person_id%type
428: ,c_end_person per_all_people_f.person_id%type
429: ,c_employee_type per_all_people_f.current_employee_flag%type
430: ,c_business_group_id hr_all_organization_units.organization_id%type
431: ,c_legal_employer hr_all_organization_units.organization_id%type
432: ,c_archive_start_date date
433: ,c_archive_end_date date
434: ) is
435: select paa.assignment_action_id,

Line 481: ,c_business_group_id hr_all_organization_units.organization_id%type

477: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
478: ,c_start_person per_all_people_f.person_id%type
479: ,c_end_person per_all_people_f.person_id%type
480: ,c_employee_type per_all_people_f.current_employee_flag%type
481: ,c_business_group_id hr_all_organization_units.organization_id%type
482: ,c_legal_employer hr_all_organization_units.organization_id%type
483: ,c_period_end_date date
484: ,c_pact_id pay_payroll_actions.payroll_action_id%type
485: ) is

Line 482: ,c_legal_employer hr_all_organization_units.organization_id%type

478: ,c_start_person per_all_people_f.person_id%type
479: ,c_end_person per_all_people_f.person_id%type
480: ,c_employee_type per_all_people_f.current_employee_flag%type
481: ,c_business_group_id hr_all_organization_units.organization_id%type
482: ,c_legal_employer hr_all_organization_units.organization_id%type
483: ,c_period_end_date date
484: ,c_pact_id pay_payroll_actions.payroll_action_id%type
485: ) is
486: select paa.assignment_action_id,

Line 525: ,c_business_group_id hr_all_organization_units.organization_id%type

521: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
522: ,c_start_person per_all_people_f.person_id%type
523: ,c_end_person per_all_people_f.person_id%type
524: ,c_employee_type per_all_people_f.current_employee_flag%type
525: ,c_business_group_id hr_all_organization_units.organization_id%type
526: ,c_payroll_id pay_payroll_actions.payroll_id%type
527: ,c_archive_start_date date
528: ,c_archive_end_date date
529: ) is

Line 575: ,c_business_group_id hr_all_organization_units.organization_id%type

571: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
572: ,c_start_person per_all_people_f.person_id%type
573: ,c_end_person per_all_people_f.person_id%type
574: ,c_employee_type per_all_people_f.current_employee_flag%type
575: ,c_business_group_id hr_all_organization_units.organization_id%type
576: ,c_payroll_id pay_payroll_actions.payroll_id%type
577: ,c_period_end_date date
578: ,c_pact_id pay_payroll_actions.payroll_action_id%type
579: ) is

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_assignment_id per_all_assignments_f.assignment_id%type
622: ,c_archive_start_date date
623: ,c_archive_end_date date
624: ) is

Line 669: ,c_business_group_id hr_all_organization_units.organization_id%type

665: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
666: ,c_start_person per_all_people_f.person_id%type
667: ,c_end_person per_all_people_f.person_id%type
668: ,c_employee_type per_all_people_f.current_employee_flag%type
669: ,c_business_group_id hr_all_organization_units.organization_id%type
670: ,c_assignment_id per_all_assignments_f.assignment_id%type
671: ,c_period_end_date date
672: ,c_pact_id pay_payroll_actions.payroll_action_id%type
673: ) is

Line 713: ,c_business_group_id hr_all_organization_units.organization_id%type

709: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
710: ,c_start_person per_all_people_f.person_id%type
711: ,c_end_person per_all_people_f.person_id%type
712: ,c_employee_type per_all_people_f.current_employee_flag%type
713: ,c_business_group_id hr_all_organization_units.organization_id%type
714: ,c_archive_start_date date
715: ,c_archive_end_date date
716: ) is
717: select paa.assignment_action_id,

Line 760: ,c_business_group_id hr_all_organization_units.organization_id%type

756: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
757: ,c_start_person per_all_people_f.person_id%type
758: ,c_end_person per_all_people_f.person_id%type
759: ,c_employee_type per_all_people_f.current_employee_flag%type
760: ,c_business_group_id hr_all_organization_units.organization_id%type
761: ,c_period_end_date date
762: ,c_pact_id pay_payroll_actions.payroll_action_id%type
763: ) is
764: select paa.assignment_action_id,

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

1547: ) is
1548:
1549:
1550:
1551: cursor c_employee_details(c_business_group_id hr_all_organization_units.organization_id%TYPE,
1552: c_assignment_id number,c_end_date date, c_start_date date) /*Bug#3662449 c_start_date parameter added*/
1553: is
1554: select pap.full_name,
1555: paa.assignment_number,

Line 1652: 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)

1648:
1649: /*Bug 5603254 - Removed tables piv2 and prrv2 and their joins from cursor , added a call to function pay_au_rec_det_archive.get_element_payment_hours to get the value for hours and rate */
1650:
1651:
1652: 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)
1653: is
1654: 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 */
1655: from
1656: (select distinct -- Bug No: 4045910