DBA Data[Home] [Help]

APPS.PER_ES_SS_REP_ARCHIVE_PKG dependencies on HR_ASSIGNMENT_SETS

Line 300: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;

296: l_unused_number NUMBER;
297: l_action_info_id pay_action_information.action_information_id%TYPE;
298: l_ovn pay_action_information.object_version_number%TYPE;
299: l_test_flag NUMBER;
300: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
301: --
302: BEGIN
303: --
304: l_unused_number := 0;

Line 556: FROM hr_assignment_sets has

552: --
553: --Fetching the payroll id for the assignment_set
554: CURSOR csr_get_payroll_id(c_assignment_set_id NUMBER,c_business_group_id NUMBER) IS
555: SELECT has.payroll_id
556: FROM hr_assignment_sets has
557: WHERE has.assignment_set_id = c_assignment_set_id
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

Line 595: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;

591: l_ss_identifier pay_element_entry_values_f.screen_entry_value%TYPE;
592: l_assignment_id per_all_assignments_f.assignment_id%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;

Line 596: l_payroll_id hr_assignment_sets.payroll_id%TYPE;

592: l_assignment_id per_all_assignments_f.assignment_id%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;