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 1244: l_business_group_id hr_organization_units.business_group_id%TYPE;

1240: l_payroll_action_message VARCHAR(240);
1241: -- vars for holding SRS Parameters:
1242: l_start_year DATE;
1243: l_end_year DATE;
1244: l_business_group_id hr_organization_units.business_group_id%TYPE;
1245: l_permit_number VARCHAR2(12);
1246: l_tax_district_reference VARCHAR2(3); -- error check will ensure numeric
1247: l_tax_reference_number VARCHAR2(10); -- 4011263: length 10 chars
1248: l_test_indicator varchar2(1); -- 5909829 EOY to store test indicator value

Line 3140: l_organization_id hr_organization_units.organization_id%TYPE;

3136: --
3137: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
3138: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3139: l_person_id per_all_people_f.person_id%TYPE;
3140: l_organization_id hr_organization_units.organization_id%TYPE;
3141: l_location_id per_all_assignments_f.location_id%TYPE;
3142: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
3143: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
3144: l_agg_active_start per_all_assignments_f.effective_start_date%TYPE;