DBA Data[Home] [Help]

APPS.ITG_SETUP dependencies on ECX_STANDARDS

Line 881: ecx_standards svl

877: ecx_tp_details tpd,
878: ecx_tp_headers tph,
879: ecx_ext_processes extp,
880: ecx_transactions txn,
881: ecx_standards svl
882: WHERE 1=1
883: AND tph.tp_header_id = tpd.tp_header_id
884: AND tpd.ext_process_id = extp.ext_process_id
885: AND extp.transaction_id = txn.transaction_id

Line 970: ecx_standards svl

966: SELECT extp.ext_process_id
967: INTO l_ext_process_id
968: FROM ecx_ext_processes extp,
969: ecx_transactions txn,
970: ecx_standards svl
971: WHERE 1=1
972: AND extp.transaction_id = txn.transaction_id
973: AND extp.standard_id = svl.standard_id
974: AND svl.standard_code = p_std_code

Line 1002: ecx_standards svl

998: SELECT count(*)
999: INTO l_count
1000: FROM ecx_ext_processes extp,
1001: ecx_tp_details tpd,
1002: ecx_standards svl
1003: WHERE 1=1
1004: AND extp.standard_id = svl.standard_id
1005: AND svl.standard_code = p_std_code
1006: AND extp.ext_process_id = tpd.ext_process_id