DBA Data[Home] [Help]

APPS.PAY_US_PTO_CO_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 406: from pay_element_entries_f pee,

402: --
403: -- This cursor is tuned as part of performance bug fix 3420490.
404: cursor csr_get_assignment is
405: select distinct pee.assignment_id assignment_id, asg.assignment_number
406: from pay_element_entries_f pee,
407: pay_element_links_f pel,
408: per_all_assignments_f asg
409: where pee.element_type_id = p_plan_ele_type_id
410: and pee.element_type_id = pel.element_type_id

Line 581: from pay_element_entries_f pee,

577: cursor csr_check_ee_exist (p_ele_link_id number,
578: p_effective_date date,
579: p_date_input_value_id number) is
580: select pee.element_entry_id
581: from pay_element_entries_f pee,
582: pay_element_entry_values_f pev
583: where pee.assignment_id = p_assignment_id
584: and pee.element_link_id = p_ele_link_id
585: and pee.element_entry_id = pev.element_entry_id