APPS.BEN_BATCH_UTILS dependencies on PER_ASSIGNMENTS_F

Line 55: ,assignment_id per_assignments_f.assignment_id%type

51: ,benefit_group_id per_people_f.benefit_group_id%type
52: ,postal_code per_addresses.postal_code%type
53: ,national_identifier per_people_f.national_identifier%type
54: ,person_has_type_emp varchar2(1)
55: ,assignment_id per_assignments_f.assignment_id%type
56: ,fte_value per_assignment_budget_values.value%type
57: ,total_fte_value per_assignment_budget_values.value%type
58: ,per_system_status per_assignment_status_types.per_system_status%type
59: ,date_start per_periods_of_service.date_start%type

Line 66: ,grade_id per_assignments_f.grade_id%type

62: ,pay_period_start_date per_time_periods.start_date%type
63: ,pay_period_end_date per_time_periods.end_date%type
64: ,pay_period_next_start_date per_time_periods.start_date%type
65: ,pay_period_next_end_date per_time_periods.end_date%type
66: ,grade_id per_assignments_f.grade_id%type
67: ,job_id per_assignments_f.job_id%type
68: ,pay_basis_id per_assignments_f.pay_basis_id%type
69: ,pay_basis per_pay_bases.pay_basis%type
70: ,payroll_id per_assignments_f.payroll_id%type

Line 67: ,job_id per_assignments_f.job_id%type

63: ,pay_period_end_date per_time_periods.end_date%type
64: ,pay_period_next_start_date per_time_periods.start_date%type
65: ,pay_period_next_end_date per_time_periods.end_date%type
66: ,grade_id per_assignments_f.grade_id%type
67: ,job_id per_assignments_f.job_id%type
68: ,pay_basis_id per_assignments_f.pay_basis_id%type
69: ,pay_basis per_pay_bases.pay_basis%type
70: ,payroll_id per_assignments_f.payroll_id%type
71: ,payroll_name pay_all_payrolls_f.payroll_name%type

Line 68: ,pay_basis_id per_assignments_f.pay_basis_id%type

64: ,pay_period_next_start_date per_time_periods.start_date%type
65: ,pay_period_next_end_date per_time_periods.end_date%type
66: ,grade_id per_assignments_f.grade_id%type
67: ,job_id per_assignments_f.job_id%type
68: ,pay_basis_id per_assignments_f.pay_basis_id%type
69: ,pay_basis per_pay_bases.pay_basis%type
70: ,payroll_id per_assignments_f.payroll_id%type
71: ,payroll_name pay_all_payrolls_f.payroll_name%type
72: ,location_id per_assignments_f.location_id%type

Line 70: ,payroll_id per_assignments_f.payroll_id%type

66: ,grade_id per_assignments_f.grade_id%type
67: ,job_id per_assignments_f.job_id%type
68: ,pay_basis_id per_assignments_f.pay_basis_id%type
69: ,pay_basis per_pay_bases.pay_basis%type
70: ,payroll_id per_assignments_f.payroll_id%type
71: ,payroll_name pay_all_payrolls_f.payroll_name%type
72: ,location_id per_assignments_f.location_id%type
73: ,address_line_1 hr_locations.address_line_1%type
74: ,organization_id per_assignments_f.organization_id%type

Line 72: ,location_id per_assignments_f.location_id%type

68: ,pay_basis_id per_assignments_f.pay_basis_id%type
69: ,pay_basis per_pay_bases.pay_basis%type
70: ,payroll_id per_assignments_f.payroll_id%type
71: ,payroll_name pay_all_payrolls_f.payroll_name%type
72: ,location_id per_assignments_f.location_id%type
73: ,address_line_1 hr_locations.address_line_1%type
74: ,organization_id per_assignments_f.organization_id%type
75: ,normal_hours per_assignments_f.normal_hours%type
76: ,frequency per_assignments_f.frequency%type

Line 74: ,organization_id per_assignments_f.organization_id%type

70: ,payroll_id per_assignments_f.payroll_id%type
71: ,payroll_name pay_all_payrolls_f.payroll_name%type
72: ,location_id per_assignments_f.location_id%type
73: ,address_line_1 hr_locations.address_line_1%type
74: ,organization_id per_assignments_f.organization_id%type
75: ,normal_hours per_assignments_f.normal_hours%type
76: ,frequency per_assignments_f.frequency%type
77: ,bargaining_unit_code per_assignments_f.bargaining_unit_code%type
78: ,hourly_salaried_code per_assignments_f.hourly_salaried_code%type

Line 75: ,normal_hours per_assignments_f.normal_hours%type

71: ,payroll_name pay_all_payrolls_f.payroll_name%type
72: ,location_id per_assignments_f.location_id%type
73: ,address_line_1 hr_locations.address_line_1%type
74: ,organization_id per_assignments_f.organization_id%type
75: ,normal_hours per_assignments_f.normal_hours%type
76: ,frequency per_assignments_f.frequency%type
77: ,bargaining_unit_code per_assignments_f.bargaining_unit_code%type
78: ,hourly_salaried_code per_assignments_f.hourly_salaried_code%type
79: ,labour_union_member_flag per_assignments_f.labour_union_member_flag%type

Line 76: ,frequency per_assignments_f.frequency%type

72: ,location_id per_assignments_f.location_id%type
73: ,address_line_1 hr_locations.address_line_1%type
74: ,organization_id per_assignments_f.organization_id%type
75: ,normal_hours per_assignments_f.normal_hours%type
76: ,frequency per_assignments_f.frequency%type
77: ,bargaining_unit_code per_assignments_f.bargaining_unit_code%type
78: ,hourly_salaried_code per_assignments_f.hourly_salaried_code%type
79: ,labour_union_member_flag per_assignments_f.labour_union_member_flag%type
80: ,assignment_status_type_id per_assignments_f.assignment_status_type_id%type

Line 77: ,bargaining_unit_code per_assignments_f.bargaining_unit_code%type

73: ,address_line_1 hr_locations.address_line_1%type
74: ,organization_id per_assignments_f.organization_id%type
75: ,normal_hours per_assignments_f.normal_hours%type
76: ,frequency per_assignments_f.frequency%type
77: ,bargaining_unit_code per_assignments_f.bargaining_unit_code%type
78: ,hourly_salaried_code per_assignments_f.hourly_salaried_code%type
79: ,labour_union_member_flag per_assignments_f.labour_union_member_flag%type
80: ,assignment_status_type_id per_assignments_f.assignment_status_type_id%type
81: ,change_reason per_assignments_f.change_reason%type

Line 78: ,hourly_salaried_code per_assignments_f.hourly_salaried_code%type

74: ,organization_id per_assignments_f.organization_id%type
75: ,normal_hours per_assignments_f.normal_hours%type
76: ,frequency per_assignments_f.frequency%type
77: ,bargaining_unit_code per_assignments_f.bargaining_unit_code%type
78: ,hourly_salaried_code per_assignments_f.hourly_salaried_code%type
79: ,labour_union_member_flag per_assignments_f.labour_union_member_flag%type
80: ,assignment_status_type_id per_assignments_f.assignment_status_type_id%type
81: ,change_reason per_assignments_f.change_reason%type
82: ,employment_category per_assignments_f.employment_category%type

Line 79: ,labour_union_member_flag per_assignments_f.labour_union_member_flag%type

75: ,normal_hours per_assignments_f.normal_hours%type
76: ,frequency per_assignments_f.frequency%type
77: ,bargaining_unit_code per_assignments_f.bargaining_unit_code%type
78: ,hourly_salaried_code per_assignments_f.hourly_salaried_code%type
79: ,labour_union_member_flag per_assignments_f.labour_union_member_flag%type
80: ,assignment_status_type_id per_assignments_f.assignment_status_type_id%type
81: ,change_reason per_assignments_f.change_reason%type
82: ,employment_category per_assignments_f.employment_category%type
83: ,org_information1 hr_organization_information.org_information1%type

Line 80: ,assignment_status_type_id per_assignments_f.assignment_status_type_id%type

76: ,frequency per_assignments_f.frequency%type
77: ,bargaining_unit_code per_assignments_f.bargaining_unit_code%type
78: ,hourly_salaried_code per_assignments_f.hourly_salaried_code%type
79: ,labour_union_member_flag per_assignments_f.labour_union_member_flag%type
80: ,assignment_status_type_id per_assignments_f.assignment_status_type_id%type
81: ,change_reason per_assignments_f.change_reason%type
82: ,employment_category per_assignments_f.employment_category%type
83: ,org_information1 hr_organization_information.org_information1%type
84: ,bg_name hr_all_organization_units.name%type

Line 81: ,change_reason per_assignments_f.change_reason%type

77: ,bargaining_unit_code per_assignments_f.bargaining_unit_code%type
78: ,hourly_salaried_code per_assignments_f.hourly_salaried_code%type
79: ,labour_union_member_flag per_assignments_f.labour_union_member_flag%type
80: ,assignment_status_type_id per_assignments_f.assignment_status_type_id%type
81: ,change_reason per_assignments_f.change_reason%type
82: ,employment_category per_assignments_f.employment_category%type
83: ,org_information1 hr_organization_information.org_information1%type
84: ,bg_name hr_all_organization_units.name%type
85: ,org_id hr_all_organization_units.organization_id%type

Line 82: ,employment_category per_assignments_f.employment_category%type

78: ,hourly_salaried_code per_assignments_f.hourly_salaried_code%type
79: ,labour_union_member_flag per_assignments_f.labour_union_member_flag%type
80: ,assignment_status_type_id per_assignments_f.assignment_status_type_id%type
81: ,change_reason per_assignments_f.change_reason%type
82: ,employment_category per_assignments_f.employment_category%type
83: ,org_information1 hr_organization_information.org_information1%type
84: ,bg_name hr_all_organization_units.name%type
85: ,org_id hr_all_organization_units.organization_id%type
86: ,org_name hr_all_organization_units.name%type