DBA Data[Home] [Help]

APPS.PAY_EVENTS_WRAPPER dependencies on PAY_ELEMENT_ENTRIES_F

Line 1069: WHERE table_name = 'PAY_ELEMENT_ENTRIES_F';

1065: BEGIN
1066: SELECT dated_table_id
1067: INTO l_element_entries_dt_id
1068: FROM pay_dated_tables
1069: WHERE table_name = 'PAY_ELEMENT_ENTRIES_F';
1070: EXCEPTION
1071: WHEN OTHERS THEN l_element_entries_dt_id := NULL;
1072: END;
1073: RETURN l_element_entries_dt_id;

Line 1086: from pay_element_entries_f pee,

1082: BEGIN
1083: --
1084: select /*+ ordered */ distinct pee.element_entry_id
1085: into l_dummy
1086: from pay_element_entries_f pee,
1087: per_all_assignments_f paf,
1088: per_pay_bases ppb,
1089: pay_element_entry_values_f peev
1090: where pee.element_entry_id = p_ee_id