DBA Data[Home] [Help]

APPS.PAY_CA_ROE_EI_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 1351: pay_element_entries_f pee,

1347: pec.classification_name,
1348: pec.classification_id,
1349: pet.element_information1
1350: from
1351: pay_element_entries_f pee,
1352: pay_element_links_f pel,
1353: pay_element_types_f pet,
1354: pay_element_entry_values_f peev,
1355: pay_input_values_f piv,

Line 1396: pay_element_entries_f pee_inner

1392: -- EXISTS condition added by sneelapa for bug 9766346 and 10236743
1393: and exists
1394: (
1395: select /*+ push_subq no_unnest */ 1 from
1396: pay_element_entries_f pee_inner
1397: where pee_inner.assignment_id=pee.assignment_id
1398: and pee_inner.entry_type = 'E'
1399: and (
1400: ( pee.creator_type = 'EE'

Line 1406: pay_element_entries_f pee_inner,

1402: )
1403: )
1404: and pee_inner.element_type_id = prcu.creator_id
1405: union select /*+ push_subq no_unnest */ 1 from
1406: pay_element_entries_f pee_inner,
1407: pay_run_results prr_inner
1408: where pee_inner.assignment_id=pee.assignment_id
1409: and pee_inner.entry_type = 'E'
1410: and (