APPS.PQP_UTILITIES dependencies on PAY_ELEMENT_ENTRIES_F

Line 3445: AND (pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'

3441: FROM pay_datetracked_events pde
3442: ,pay_dated_tables pdt
3443: WHERE event_group_id = p_event_group_id
3444: AND pde.dated_table_id = pdt.dated_table_id
3445: AND (pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
3446: OR
3447: pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
3448: )
3449: AND ROWNUM < 2;

Line 3485: ,pay_element_entries_f pee

3481: IS
3482: SELECT distinct pee.element_entry_id
3483: ,pde.datetracked_event_id
3484: FROM pay_element_set_members pes
3485: ,pay_element_entries_f pee
3486: ,pay_datetracked_events pde
3487: WHERE pes.element_set_id = p_element_set_id
3488: AND pee.element_type_id = pes.element_type_id
3489: AND pee.assignment_id = p_assignment_id

Line 3511: AND pdt.table_name = 'PAY_ELEMENT_ENTRIES_F';

3507: ,pay_dated_tables pdt
3508: WHERE event_group_id = p_event_group_id
3509: AND pde.dated_table_id = pdt.dated_table_id
3510: AND pde.update_type = 'P'
3511: AND pdt.table_name = 'PAY_ELEMENT_ENTRIES_F';
3512:
3513:
3514: -- this is used to fetch the element entry ids of the
3515: -- puged element entries.