DBA Data[Home] [Help]

APPS.PSB_WRHR_EXTRACT_PROCESS dependencies on PSB_REENTRANT_PROCESS_STATUS

Line 420: delete psb_reentrant_process_status

416: end;
417:
418: /* Commented for bug 3325056 .. Start
419: begin
420: delete psb_reentrant_process_status
421: where process_uid = C_Interface_Rec.data_extract_id
422: and process_type = 'HR DATA EXTRACT';
423:
424: commit work;

Line 3049: from psb_reentrant_process_status

3045: nvl(sp15_status,'I') sp15_status,
3046: nvl(sp16_status,'I') sp16_status,
3047: nvl(sp17_status,'I') sp17_status,
3048: nvl(sp18_status,'I') sp18_status
3049: from psb_reentrant_process_status
3050: where process_type = 'HR DATA EXTRACT'
3051: and process_uid = p_data_extract_id;
3052:
3053: Cursor C_Extract_Status is

Line 3196: from psb_reentrant_process_status

3192: l_sp15_status,
3193: l_sp16_status,
3194: l_sp17_status,
3195: l_sp18_status
3196: from psb_reentrant_process_status
3197: where process_type = 'HR DATA EXTRACT'
3198: and process_uid = p_data_extract_id;
3199:
3200: exception