DBA Data[Home] [Help]

APPS.ASO_DEFAULTING_UTIL dependencies on HZ_PARTIES

Line 45: FROM HZ_PARTIES

41: IS
42:
43: CURSOR C_Party_Type(lc_party_id NUMBER) IS
44: SELECT Party_Type
45: FROM HZ_PARTIES
46: WHERE Party_Id = lc_party_id;
47:
48: CURSOR C_Line_Party_Type(lc_quote_header_id NUMBER) IS
49: SELECT pty.Party_Type

Line 50: FROM HZ_PARTIES pty, ASO_QUOTE_HEADERS_ALL hdr

46: WHERE Party_Id = lc_party_id;
47:
48: CURSOR C_Line_Party_Type(lc_quote_header_id NUMBER) IS
49: SELECT pty.Party_Type
50: FROM HZ_PARTIES pty, ASO_QUOTE_HEADERS_ALL hdr
51: WHERE pty.Party_Id = hdr.cust_party_id
52: AND hdr.quote_header_id = lc_quote_header_id;
53:
54: CURSOR C_Product (lc_inv_item_id NUMBER, lc_organization_id NUMBER) IS