APPS.PAY_AU_PAYMENT_SUMMARY dependencies on HR_ALL_ORGANIZATION_UNITS

Line 8182: ,c_business_group_id hr_all_organization_units.organization_id%TYPE

8178: ----------------------------------------------------------------------------------------+
8179: --
8180: cursor c_max_asg_action_id
8181: (c_assignment_id per_all_assignments_f.assignment_id%TYPE
8182: ,c_business_group_id hr_all_organization_units.organization_id%TYPE
8183: ,c_tax_unit_id hr_all_organization_units.organization_id%TYPE
8184: ,c_year_start date
8185: ,c_year_end date
8186: ) is

Line 8183: ,c_tax_unit_id hr_all_organization_units.organization_id%TYPE

8179: --
8180: cursor c_max_asg_action_id
8181: (c_assignment_id per_all_assignments_f.assignment_id%TYPE
8182: ,c_business_group_id hr_all_organization_units.organization_id%TYPE
8183: ,c_tax_unit_id hr_all_organization_units.organization_id%TYPE
8184: ,c_year_start date
8185: ,c_year_end date
8186: ) is
8187: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id,

Line 8271: ,c_tax_unit_id hr_all_organization_units.organization_id%TYPE

8267: /* Bug 9872891 - Added new cursor to get effective date when ETP payments
8268: have been made for previously terminated employees */
8269: CURSOR c_etp_max_pay_date
8270: (c_assignment_id per_all_assignments_f.assignment_id%TYPE
8271: ,c_tax_unit_id hr_all_organization_units.organization_id%TYPE
8272: ,c_year_start DATE
8273: ,c_year_end DATE
8274: ) is
8275: SELECT max(ppa.effective_date) effective_date