DBA Data[Home] [Help]

APPS.PER_ABS_BUS dependencies on PAY_ELEMENT_ENTRIES_F

Line 102: pay_element_entries_f pee,

98: select /*+ leading(PAA) */ nvl(fnd_number.canonical_to_number(pev.screen_entry_value), 0),
99: pev.effective_start_date,
100: pev.effective_end_date
101: from pay_element_entry_values_f pev,
102: pay_element_entries_f pee,
103: per_all_assignments_f paa,
104: per_absence_attendance_types abt
105: where pev.element_entry_id = pee.element_entry_id
106: and pev.input_value_id = abt.input_value_id

Line 1962: from pay_element_entries_f pee,

1958: and abt.absence_category = 'S';
1959:
1960: cursor c_get_accrual_plans (p_assignment_id in number) is
1961: select pap.accrual_plan_id, asg.payroll_id
1962: from pay_element_entries_f pee,
1963: pay_element_links_f pel,
1964: pay_element_types_f pet,
1965: pay_input_values_f piv,
1966: per_all_assignments_f asg,