APPS.M4U_CLN_PKG dependencies on ECX_TP_HEADERS

Line 838: ecx_tp_headers tph,

834: SELECT tp_detail_id
835: INTO l_tp_dtl_id
836: FROM
837: ecx_tp_details tpd,
838: ecx_tp_headers tph,
839: ecx_ext_processes extp,
840: ecx_transactions txn,
841: ecx_standards svl
842: WHERE 1=1

Line 1086: l_progress := 'Query ecx_tp_headers : party_id - ' || l_location_id;

1082: -- reset the value for next phase
1083: l_record_found := FALSE;
1084: -----------------------------------------------------------------------------
1085: --Query TP Header Id
1086: l_progress := 'Query ecx_tp_headers : party_id - ' || l_location_id;
1087: -- Check if record exists. Create TP Header if it does not else Update value
1088: BEGIN
1089: SELECT tp_header_id
1090: INTO l_tp_hdr_id

Line 1091: FROM ecx_tp_headers

1087: -- Check if record exists. Create TP Header if it does not else Update value
1088: BEGIN
1089: SELECT tp_header_id
1090: INTO l_tp_hdr_id
1091: FROM ecx_tp_headers
1092: WHERE party_type = 'I'
1093: AND party_id = l_location_id
1094: AND party_site_id = l_location_id;
1095:

Line 1188: ecx_tp_headers e

1184: /* Package initialization. */
1185: SELECT to_char(e.party_id), to_char(e.party_site_id)
1186: INTO g_party_id, g_party_site_id
1187: FROM hr_locations_all h,
1188: ecx_tp_headers e
1189: WHERE h.location_id = e.party_id
1190: AND e.party_type = m4u_cln_pkg.c_party_type
1191: AND h.location_code = m4u_cln_pkg.c_party_site;
1192: