DBA Data[Home] [Help]

APPS.PAY_US_PTO_CO_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 413: from pay_element_entries_f pee,

409:
410: /*
411: cursor csr_get_assignment is
412: select distinct pee.assignment_id assignment_id, asg.assignment_number
413: from pay_element_entries_f pee,
414: pay_element_links_f pel,
415: per_all_assignments_f asg
416: where pee.element_type_id = p_plan_ele_type_id
417: and pee.element_type_id = pel.element_type_id

Line 428: from pay_element_entries_f pee,

424: */
425:
426: cursor csr_get_assignment is
427: select distinct pee.assignment_id assignment_id, asg.assignment_number
428: from pay_element_entries_f pee,
429: pay_element_links_f pel,
430: per_all_assignments_f asg,
431: per_periods_of_service pds
432: where pee.element_type_id = p_plan_ele_type_id

Line 609: from pay_element_entries_f pee,

605: cursor csr_check_ee_exist (p_ele_link_id number,
606: p_effective_date date,
607: p_date_input_value_id number) is
608: select pee.element_entry_id
609: from pay_element_entries_f pee,
610: pay_element_entry_values_f pev
611: where pee.assignment_id = p_assignment_id
612: and pee.element_link_id = p_ele_link_id
613: and pee.element_entry_id = pev.element_entry_id