APPS.PAY_FR_TERMINATION_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 86: per_all_assignments_f assign,

82: assign.establishment_id,
83: assign.period_of_service_id,
84: substr(hruserdt.get_table_value (assign.business_group_id,'FR_CIPDZ','CIPDZ',assign.employment_category,P_termination_date),1,1) part_time_flag
85: from
86: per_all_assignments_f assign,
87: --
88: per_contracts_f contract
89: where assign.person_id = c_person_id
90: --

Line 290: from per_all_assignments_f

286: l_10_years_ago := add_months (p_termination_date,-120);
287:
288: select distinct person_id
289: into l_person_id
290: from per_all_assignments_f
291: where assignment_id = p_assignment_id
292: and business_group_id = p_business_group_id;
293:
294: select min(start_date)