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 1125: from per_all_assignments_f ASSIGN

1121:
1122: cursor c_get_salary_basis_element(cp_assignment_id number,
1123: cp_date in date) is
1124: select ETYPE.element_type_id, ETYPE.element_name
1125: from per_all_assignments_f ASSIGN
1126: ,per_pay_bases BASES
1127: ,pay_input_values_f INPUTV
1128: ,pay_element_types_f ETYPE
1129: ,pay_rates RATE