DBA Data[Home] [Help]

APPS.PA_PROJECT_REQUEST_PVT dependencies on HZ_PARTIES

Line 566: hz_parties p,

562: p.party_name customer_orgnization,
563: r.request_type
564: FROM
565: pa_project_requests r,
566: hz_parties p,
567: hz_party_sites s,
568: hz_cust_accounts a,
569: hz_locations lc,
570: fnd_territories_vl ft

Line 1098: hz_parties p,

1094: l.state,
1095: l.city
1096: FROM
1097: pa_project_requests r,
1098: hz_parties p,
1099: hz_party_sites s,
1100: hz_locations l
1101: WHERE
1102: r.cust_party_id = p.party_id(+)

Line 1111: l_request_customer hz_parties.party_name%TYPE;

1107: -- ORA-02014 error. Locking is not necessary for this cursor.
1108: -- FOR UPDATE
1109: -- End of 2910113
1110:
1111: l_request_customer hz_parties.party_name%TYPE;
1112: l_country hz_locations.country%TYPE;
1113: l_state hz_locations.state%TYPE;
1114: l_city hz_locations.city%TYPE;
1115: l_account_id NUMBER;