APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on PAY_PROCESS_EVENTS

Line 424: -- since pay process events might have completed

420: WHERE pqea.ext_dfn_type = g_extract_type
421: AND rslt.ext_dfn_id = pqea.ext_dfn_id
422: AND rslt.business_group_id = g_business_group_id
423: -- even failed future runs are to be considered
424: -- since pay process events might have completed
425: -- AND rslt.ext_stat_cd NOT IN
426: -- ('F' -- Job Failure
427: -- ,'R' -- Rejected By User
428: -- ,'X' -- Executing

Line 1674: -- Mark pay_process_events to process

1670: debug('p_start_date: '||fnd_date.date_to_canonical(p_start_date));
1671: debug('p_end_date: '||fnd_date.date_to_canonical(p_end_date));
1672:
1673: --
1674: -- Mark pay_process_events to process
1675: -- as determined by the date range. The maxmim allowed range
1676: -- is the last eff date and a day before the current eff date
1677:
1678: UPDATE pay_process_events

Line 1678: UPDATE pay_process_events

1674: -- Mark pay_process_events to process
1675: -- as determined by the date range. The maxmim allowed range
1676: -- is the last eff date and a day before the current eff date
1677:
1678: UPDATE pay_process_events
1679: SET retroactive_status = p_status
1680: ,status = p_status
1681: WHERE assignment_id = p_assignment_id
1682: AND change_type = 'REPORTS'