APPS.ECX_TP_SYNCH dependencies on PO_VENDOR_SITES_ALL

Line 55: select p1.ADDRESS_LINE1||' '||p1.ADDRESS_LINE2||' '||p1.ADDRESS_LINE3||' '||p1.CITY||p1.ZIP from PO_VENDOR_SITES_ALL p1

51: cursor supplier_party_name(v_party_id varchar) is
52: select p.vendor_name from PO_VENDORS p where p.vendor_ID =v_party_id;
53:
54: cursor supplier_site_name(v_party_id varchar,v_party_site_id varchar) is
55: select p1.ADDRESS_LINE1||' '||p1.ADDRESS_LINE2||' '||p1.ADDRESS_LINE3||' '||p1.CITY||p1.ZIP from PO_VENDOR_SITES_ALL p1
56: where p1.VENDOR_SITE_ID =v_party_site_id and p1.VENDOR_ID=v_party_id;
57:
58:
59: cursor customer_party_name(v_party_id varchar) is

Line 71: select decode(party_type,'C','HZ_PARTY_SITES','EXCHANGE','HZ_PARTY_SITES','CARRIER','HZ_PARTY_SITES','S','PO_VENDOR_SITES_ALL','I','HR_LOCATIONS_SITES','B','CE_BANK_BRANCHES_SITE') from ecx_tp_headers where party_id =v_party_id ;

67: cursor org_table(v_party_id varchar) is
68: select decode(party_type,'C','HZ_PARTIES','EXCHANGE','HZ_PARTIES','CARRIER','HZ_PARTIES','S','PO_VENDORS','I','HR_LOCATIONS','B','CE_BANK_BRANCHES_V') from ecx_tp_headers where party_id =v_party_id ;
69:
70: cursor org_table_site(v_party_id varchar) is
71: select decode(party_type,'C','HZ_PARTY_SITES','EXCHANGE','HZ_PARTY_SITES','CARRIER','HZ_PARTY_SITES','S','PO_VENDOR_SITES_ALL','I','HR_LOCATIONS_SITES','B','CE_BANK_BRANCHES_SITE') from ecx_tp_headers where party_id =v_party_id ;
72:
73:
74: begin
75: OPEN get_party_id;