DBA Data[Home] [Help]

APPS.PQP_UTILITIES dependencies on PAY_DATED_TABLES

Line 3442: ,pay_dated_tables pdt

3438: CURSOR csr_chk_eg_for_ee_tab
3439: IS
3440: SELECT 'Y'
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

Line 3507: ,pay_dated_tables pdt

3503: CURSOR csr_get_purge_events_on_eg
3504: IS
3505: SELECT datetracked_event_id
3506: FROM pay_datetracked_events pde
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';