DBA Data[Home] [Help]

APPS.PAY_HK_AVG_PAY dependencies on PAY_ELEMENT_ENTRIES_F

Line 88: pay_element_entries_f pee

84: SELECT min(pea.date_start)
85: FROM
86: per_all_assignments_f paa,
87: per_absence_attendances pea,
88: pay_element_entries_f pee
89: WHERE pee.assignment_id=p_assignment_id
90: AND paa.assignment_id=pee.assignment_id
91: AND pea.person_id = paa.person_id
92: AND pee.creator_type='A'

Line 132: pay_element_entries_f pee,

128: CURSOR csr_get_specified_date
129: IS
130: SELECT fnd_date.canonical_to_date(peev.screen_entry_value)
131: FROM
132: pay_element_entries_f pee,
133: pay_element_entry_values_f peev,
134: pay_element_types_f pet,
135: pay_input_values_f pivf
136: WHERE pee.assignment_id=p_assignment_id