APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 75: g_business_group_id hr_all_organization_units.organization_id%type;

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:
79: g_package constant varchar2(60) := 'pay_au_rec_det_paysum_mode.'; -- Global to store package name for tracing.

Line 437: ,c_business_group_id hr_all_organization_units.organization_id%type

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
438: ,c_legal_employer pay_assignment_actions.tax_unit_id%type
439: ,c_payroll_id varchar2
440: ,c_fin_year_start date
441: ,c_fin_year_end date

Line 511: ,c_business_group_id hr_all_organization_units.organization_id%type

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
512: ,c_legal_employer pay_assignment_actions.tax_unit_id%type
513: ,c_payroll_id varchar2
514: ,c_fin_year_start date
515: ,c_fin_year_end date

Line 588: ,c_business_group_id hr_all_organization_units.organization_id%type

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
590: ,c_payroll_id varchar2
591: ,c_fin_year_start date
592: ,c_fin_year_end date

Line 900: ( c_business_group_id hr_all_organization_units.organization_id%TYPE,

896: -- Description : Fetches employee details to be displayed on Report.
897: -- Latest Values as on End Date is fetched.
898: --------------------------------------------------------------------+
899: cursor c_employee_details
900: ( c_business_group_id hr_all_organization_units.organization_id%TYPE,
901: c_archive_assignment_action_id number,
902: c_start_date date,
903: c_end_date date)
904: is

Line 989: ( c_business_group_id hr_all_organization_units.organization_id%TYPE,

985: -- Summary Report - Pay Sum Mode
986: -- Latest Values as on End Date is fetched.
987: --------------------------------------------------------------------+
988: cursor c_summary_employee_details
989: ( c_business_group_id hr_all_organization_units.organization_id%TYPE,
990: c_archive_assignment_action_id number,
991: c_start_date date,
992: c_end_date date)
993: is

Line 1531: c_business_group_id hr_all_organization_units.organization_id%TYPE,

1527: /*Bug 5846278 - Added Lump Sum E Payments in Not exists Clause */
1528:
1529: cursor c_ps_element_details
1530: (c_assignment_id pay_assignment_actions.assignment_id%TYPE,
1531: c_business_group_id hr_all_organization_units.organization_id%TYPE,
1532: c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE,
1533: c_start_date date,
1534: c_end_date date)
1535: is