DBA Data[Home] [Help]

APPS.PAY_GB_EOY_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 11: g_business_group_id hr_organization_units.business_group_id%TYPE;

7: -- Globals populated by archinit procedure or action_creation proc
8: g_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
9: g_start_year DATE;
10: g_end_year DATE;
11: g_business_group_id hr_organization_units.business_group_id%TYPE;
12: g_permit_number VARCHAR2(12);
13: g_tax_district_reference VARCHAR2(3);
14: g_asg_set_id hr_assignment_sets.assignment_set_id%type;
15: g_context_id number;

Line 1220: l_business_group_id hr_organization_units.business_group_id%TYPE;

1216: l_payroll_action_message VARCHAR(240);
1217: -- vars for holding SRS Parameters:
1218: l_start_year DATE;
1219: l_end_year DATE;
1220: l_business_group_id hr_organization_units.business_group_id%TYPE;
1221: l_permit_number VARCHAR2(12);
1222: l_tax_district_reference VARCHAR2(3); -- error check will ensure numeric
1223: l_tax_reference_number VARCHAR2(10); -- 4011263: length 10 chars
1224: l_test_indicator varchar2(1); -- 5909829 EOY to store test indicator value

Line 3025: l_organization_id hr_organization_units.organization_id%TYPE;

3021: --
3022: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
3023: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3024: l_person_id per_all_people_f.person_id%TYPE;
3025: l_organization_id hr_organization_units.organization_id%TYPE;
3026: l_location_id per_all_assignments_f.location_id%TYPE;
3027: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
3028: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
3029: l_agg_active_start per_all_assignments_f.effective_start_date%TYPE;