APPS.PER_ES_SS_REP_ARCHIVE_PKG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 562: FROM hr_assignment_set_amendments hasa

558: AND has.business_group_id = c_business_group_id;
559: --
560: CURSOR csr_incl_excl(c_assignment_id NUMBER,c_assignment_set_id NUMBER) IS
561: SELECT include_or_exclude
562: FROM hr_assignment_set_amendments hasa
563: WHERE hasa.assignment_set_id = c_assignment_set_id
564: AND hasa.assignment_id = c_assignment_id;
565: --
566: CURSOR csr_province_code(c_assignment_id NUMBER

Line 597: l_incl_excl hr_assignment_set_amendments.include_or_exclude%TYPE;

593: l_relationship_type pay_element_entry_values_f.screen_entry_value%TYPE;
594: l_retirement_age_reduction pay_element_entry_values_f.screen_entry_value%TYPE;
595: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
596: l_payroll_id hr_assignment_sets.payroll_id%TYPE;
597: l_incl_excl hr_assignment_set_amendments.include_or_exclude%TYPE;
598: l_legal_employer hr_all_organization_units.organization_id%TYPE;
599: l_province_code per_addresses.region_2%TYPE;
600: l_ss_number pay_element_entry_values_f.screen_entry_value%TYPE;
601: --