DBA Data[Home] [Help]

APPS.PAY_FF_FUNCTIONS dependencies on PER_ALL_ASSIGNMENTS_F

Line 290: per_all_assignments_f ass

286:
287: Cursor C2 is
288: SELECT max(service.date_start) start_date
289: FROM per_periods_of_service service,
290: per_all_assignments_f ass
291: WHERE ass.assignment_id = p_assignment_id
292: AND ass.person_id = service.person_id
293: AND service.date_start <= l_effective_date;
294:

Line 442: per_all_assignments_f ass

438: l_effective_date date;
439: cursor c1 is
440: SELECT max(service.date_start) start_date
441: FROM per_periods_of_service service,
442: per_all_assignments_f ass
443: WHERE ass.assignment_id = p_assignment_id
444: AND ass.person_id = service.person_id
445: AND service.date_start <= l_effective_date;
446:

Line 1104: from per_all_assignments_f ASSIGN

1100:
1101: cursor c_get_salary_basis_element(cp_assignment_id number,
1102: cp_date in date) is
1103: select ETYPE.element_type_id, ETYPE.element_name
1104: from per_all_assignments_f ASSIGN
1105: ,per_pay_bases BASES
1106: ,pay_input_values_f INPUTV
1107: ,pay_element_types_f ETYPE
1108: ,pay_rates RATE