APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on PER_ASSIGNMENTS_F

Line 35: ,assignment_id per_assignments_f.assignment_id%type

31: ,benefit_group ben_benfts_grp.name%type
32: ,benefit_group_id per_people_f.benefit_group_id%type
33: ,postal_code per_addresses.postal_code%type
34: ,person_has_type_emp varchar2(1)
35: ,assignment_id per_assignments_f.assignment_id%type
36: ,per_system_status per_assignment_status_types.per_system_status%type
37: ,date_start per_periods_of_service.date_start%type
38: ,adjusted_svc_date per_periods_of_service.adjusted_svc_date%type
39: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type

Line 44: ,grade_id per_assignments_f.grade_id%type

40: ,pay_period_start_date per_time_periods.start_date%type
41: ,pay_period_end_date per_time_periods.end_date%type
42: ,pay_period_next_start_date per_time_periods.start_date%type
43: ,pay_period_next_end_date per_time_periods.end_date%type
44: ,grade_id per_assignments_f.grade_id%type
45: ,job_id per_assignments_f.job_id%type
46: ,pay_basis_id per_assignments_f.pay_basis_id%type
47: ,pay_basis per_pay_bases.pay_basis%type
48: ,payroll_id per_assignments_f.payroll_id%type

Line 45: ,job_id per_assignments_f.job_id%type

41: ,pay_period_end_date per_time_periods.end_date%type
42: ,pay_period_next_start_date per_time_periods.start_date%type
43: ,pay_period_next_end_date per_time_periods.end_date%type
44: ,grade_id per_assignments_f.grade_id%type
45: ,job_id per_assignments_f.job_id%type
46: ,pay_basis_id per_assignments_f.pay_basis_id%type
47: ,pay_basis per_pay_bases.pay_basis%type
48: ,payroll_id per_assignments_f.payroll_id%type
49: ,payroll_name pay_all_payrolls_f.payroll_name%type

Line 46: ,pay_basis_id per_assignments_f.pay_basis_id%type

42: ,pay_period_next_start_date per_time_periods.start_date%type
43: ,pay_period_next_end_date per_time_periods.end_date%type
44: ,grade_id per_assignments_f.grade_id%type
45: ,job_id per_assignments_f.job_id%type
46: ,pay_basis_id per_assignments_f.pay_basis_id%type
47: ,pay_basis per_pay_bases.pay_basis%type
48: ,payroll_id per_assignments_f.payroll_id%type
49: ,payroll_name pay_all_payrolls_f.payroll_name%type
50: ,location_id per_assignments_f.location_id%type

Line 48: ,payroll_id per_assignments_f.payroll_id%type

44: ,grade_id per_assignments_f.grade_id%type
45: ,job_id per_assignments_f.job_id%type
46: ,pay_basis_id per_assignments_f.pay_basis_id%type
47: ,pay_basis per_pay_bases.pay_basis%type
48: ,payroll_id per_assignments_f.payroll_id%type
49: ,payroll_name pay_all_payrolls_f.payroll_name%type
50: ,location_id per_assignments_f.location_id%type
51: ,address_line_1 hr_locations.address_line_1%type
52: ,organization_id per_assignments_f.organization_id%type

Line 50: ,location_id per_assignments_f.location_id%type

46: ,pay_basis_id per_assignments_f.pay_basis_id%type
47: ,pay_basis per_pay_bases.pay_basis%type
48: ,payroll_id per_assignments_f.payroll_id%type
49: ,payroll_name pay_all_payrolls_f.payroll_name%type
50: ,location_id per_assignments_f.location_id%type
51: ,address_line_1 hr_locations.address_line_1%type
52: ,organization_id per_assignments_f.organization_id%type
53: ,normal_hours per_assignments_f.normal_hours%type
54: ,frequency per_assignments_f.frequency%type

Line 52: ,organization_id per_assignments_f.organization_id%type

48: ,payroll_id per_assignments_f.payroll_id%type
49: ,payroll_name pay_all_payrolls_f.payroll_name%type
50: ,location_id per_assignments_f.location_id%type
51: ,address_line_1 hr_locations.address_line_1%type
52: ,organization_id per_assignments_f.organization_id%type
53: ,normal_hours per_assignments_f.normal_hours%type
54: ,frequency per_assignments_f.frequency%type
55: ,bargaining_unit_code per_assignments_f.bargaining_unit_code%type
56: ,labour_union_member_flag per_assignments_f.labour_union_member_flag%type

Line 53: ,normal_hours per_assignments_f.normal_hours%type

49: ,payroll_name pay_all_payrolls_f.payroll_name%type
50: ,location_id per_assignments_f.location_id%type
51: ,address_line_1 hr_locations.address_line_1%type
52: ,organization_id per_assignments_f.organization_id%type
53: ,normal_hours per_assignments_f.normal_hours%type
54: ,frequency per_assignments_f.frequency%type
55: ,bargaining_unit_code per_assignments_f.bargaining_unit_code%type
56: ,labour_union_member_flag per_assignments_f.labour_union_member_flag%type
57: ,assignment_status_type_id per_assignments_f.assignment_status_type_id%type

Line 54: ,frequency per_assignments_f.frequency%type

50: ,location_id per_assignments_f.location_id%type
51: ,address_line_1 hr_locations.address_line_1%type
52: ,organization_id per_assignments_f.organization_id%type
53: ,normal_hours per_assignments_f.normal_hours%type
54: ,frequency per_assignments_f.frequency%type
55: ,bargaining_unit_code per_assignments_f.bargaining_unit_code%type
56: ,labour_union_member_flag per_assignments_f.labour_union_member_flag%type
57: ,assignment_status_type_id per_assignments_f.assignment_status_type_id%type
58: ,change_reason per_assignments_f.change_reason%type

Line 55: ,bargaining_unit_code per_assignments_f.bargaining_unit_code%type

51: ,address_line_1 hr_locations.address_line_1%type
52: ,organization_id per_assignments_f.organization_id%type
53: ,normal_hours per_assignments_f.normal_hours%type
54: ,frequency per_assignments_f.frequency%type
55: ,bargaining_unit_code per_assignments_f.bargaining_unit_code%type
56: ,labour_union_member_flag per_assignments_f.labour_union_member_flag%type
57: ,assignment_status_type_id per_assignments_f.assignment_status_type_id%type
58: ,change_reason per_assignments_f.change_reason%type
59: ,employment_category per_assignments_f.employment_category%type

Line 56: ,labour_union_member_flag per_assignments_f.labour_union_member_flag%type

52: ,organization_id per_assignments_f.organization_id%type
53: ,normal_hours per_assignments_f.normal_hours%type
54: ,frequency per_assignments_f.frequency%type
55: ,bargaining_unit_code per_assignments_f.bargaining_unit_code%type
56: ,labour_union_member_flag per_assignments_f.labour_union_member_flag%type
57: ,assignment_status_type_id per_assignments_f.assignment_status_type_id%type
58: ,change_reason per_assignments_f.change_reason%type
59: ,employment_category per_assignments_f.employment_category%type
60: ,org_information1 hr_organization_information.org_information1%type

Line 57: ,assignment_status_type_id per_assignments_f.assignment_status_type_id%type

53: ,normal_hours per_assignments_f.normal_hours%type
54: ,frequency per_assignments_f.frequency%type
55: ,bargaining_unit_code per_assignments_f.bargaining_unit_code%type
56: ,labour_union_member_flag per_assignments_f.labour_union_member_flag%type
57: ,assignment_status_type_id per_assignments_f.assignment_status_type_id%type
58: ,change_reason per_assignments_f.change_reason%type
59: ,employment_category per_assignments_f.employment_category%type
60: ,org_information1 hr_organization_information.org_information1%type
61: ,bg_name hr_all_organization_units.name%type

Line 58: ,change_reason per_assignments_f.change_reason%type

54: ,frequency per_assignments_f.frequency%type
55: ,bargaining_unit_code per_assignments_f.bargaining_unit_code%type
56: ,labour_union_member_flag per_assignments_f.labour_union_member_flag%type
57: ,assignment_status_type_id per_assignments_f.assignment_status_type_id%type
58: ,change_reason per_assignments_f.change_reason%type
59: ,employment_category per_assignments_f.employment_category%type
60: ,org_information1 hr_organization_information.org_information1%type
61: ,bg_name hr_all_organization_units.name%type
62: ,org_id hr_all_organization_units.organization_id%type

Line 59: ,employment_category per_assignments_f.employment_category%type

55: ,bargaining_unit_code per_assignments_f.bargaining_unit_code%type
56: ,labour_union_member_flag per_assignments_f.labour_union_member_flag%type
57: ,assignment_status_type_id per_assignments_f.assignment_status_type_id%type
58: ,change_reason per_assignments_f.change_reason%type
59: ,employment_category per_assignments_f.employment_category%type
60: ,org_information1 hr_organization_information.org_information1%type
61: ,bg_name hr_all_organization_units.name%type
62: ,org_id hr_all_organization_units.organization_id%type
63: ,org_name hr_all_organization_units.name%type