APPS.HR_DELTA_SYNC_MESSAGES dependencies on ECX_OUT_PROCESS_V

Line 110: from ecx_out_process_v prcs

106: and cntry.status in ('QUEUED','SENT'));
107:
108: cursor csr_gen_msg(p_evn_key varchar2)
109: is select generation_status,generation_message
110: from ecx_out_process_v prcs
111: where document_id = p_evn_key;
112:
113: cursor fet_delta_status
114: is

Line 319: from ecx_out_process_v prcs

315: and status = 'COMPLETED';
316:
317: cursor csr_gen_msg(p_evn_key varchar2)
318: is select generation_status,generation_message
319: from ecx_out_process_v prcs
320: where document_id = p_evn_key;
321:
322: cursor fet_state_sync(p_max_run_date date) is
323: select ft.territory_code,fcl.lookup_code,fcl.meaning,fcl.enabled_flag,fcl.last_update_date

Line 564: from ecx_out_process_v prcs

560: p_max_run_date date;
561:
562: cursor csr_gen_msg(p_evn_key varchar2)
563: is select generation_status,generation_message
564: from ecx_out_process_v prcs
565: where document_id = p_evn_key;
566:
567: cursor fet_loc_sync(p_max_run_date date) is
568: select BUSINESS_GROUP_ID,

Line 1024: from ecx_out_process_v prcs

1020: p_effective_date date default sysdate;
1021:
1022: cursor csr_gen_msg(p_evn_key varchar2)
1023: is select generation_status,generation_message
1024: from ecx_out_process_v prcs
1025: where document_id = p_evn_key;
1026:
1027: cursor fet_delta_status
1028: is

Line 1456: from ecx_out_process_v prcs

1452: and status = 'STARTED';
1453:
1454: cursor csr_gen_msg(p_evn_key varchar2)
1455: is select generation_status,generation_message
1456: from ecx_out_process_v prcs
1457: where document_id = p_evn_key;
1458:
1459: cursor fet_delta_status
1460: is

Line 1881: from ecx_out_process_v prcs

1877: where status = 'QUEUED';
1878:
1879: cursor csr_gen_msg(p_evn_key varchar2)
1880: is select generation_status,generation_message
1881: from ecx_out_process_v prcs
1882: where document_id = p_evn_key;
1883:
1884:
1885:

Line 2187: from ecx_out_process_v prcs

2183: and orgn.status in ('QUEUED','SENT'));
2184:
2185: cursor csr_gen_msg(p_evn_key varchar2)
2186: is select generation_status,generation_message
2187: from ecx_out_process_v prcs
2188: where document_id = p_evn_key;
2189:
2190: cursor fet_delta_status
2191: is

Line 2463: from ecx_out_process_v prcs

2459: and last_update_date >= p_lstupd_date;
2460:
2461: cursor csr_gen_msg(p_evn_key varchar2)
2462: is select generation_status,generation_message
2463: from ecx_out_process_v prcs
2464: where document_id = p_evn_key;
2465:
2466: p_event_key_gen varchar2(50);
2467:

Line 2662: from ecx_out_process_v prcs

2658: and pyrl.status in ('QUEUED','SENT'));
2659:
2660: cursor csr_gen_msg(p_evn_key varchar2)
2661: is select generation_status,generation_message
2662: from ecx_out_process_v prcs
2663: where document_id = p_evn_key;
2664:
2665: cursor fet_delta_status
2666: is