DBA Data[Home] [Help]

APPS.ECX_WF_ERRORS dependencies on ECX_TP_DETAILS

Line 995: l_party_site_id ecx_tp_details.source_tp_location_code%type;

991: l_party_type ecx_transactions.party_type%type;
992: i_transaction_id ecx_transactions.transaction_id%type;
993: l_standard_code ecx_standards.standard_code%type;
994: l_standard_type ecx_standards.standard_type%type;
995: l_party_site_id ecx_tp_details.source_tp_location_code%type;
996: Begin
997:
998:
999: -- RUN mode - normal process execution

Line 1039: ecx_tp_details etd,

1035: select distinct et.transaction_id,usr.email_address
1036: into i_transaction_id,i_email_addr
1037: from ecx_ext_processes eep,
1038: ecx_standards es,
1039: ecx_tp_details etd,
1040: ecx_tp_headers eth,
1041: ecx_transactions et,
1042: fnd_user usr
1043: where eep.ext_type = l_transaction_type