APPS.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on HZ_PARTIES

Line 1044: HZ_PARTIES cust_party,

1040: OKC_STATUSES_B status,
1041: OKC_STATUSES_TL status_tl,
1042: OKC_K_PARTY_ROLES_B cust_party_roles,
1043: fnd_lookup_values_vl lookup_book_class,
1044: HZ_PARTIES cust_party,
1045: HZ_CUST_ACCOUNTS cust_accounts,
1046: OKL_PRODUCTS pdt,
1047: OKL_PRODUCTS rpt_pdt,
1048: OKC_K_HEADERS_ALL_B vendor_chr,

Line 1176: --sechawla : P_CUSTOMER_NAME is hz_parties.party_id. value set: OKL_CUSTOMERS

1172:
1173: --there is no ID defined in the value set OKS_CUSTOMER_NUMBER. value is 'party_number'.
1174: AND cust_party.PARTY_NUMBER like nvl(P_CUSTOMER_NUMBER, cust_party.PARTY_NUMBER)
1175:
1176: --sechawla : P_CUSTOMER_NAME is hz_parties.party_id. value set: OKL_CUSTOMERS
1177: AND cust_party.party_id = nvl(P_CUSTOMER_NAME, cust_party.party_id)
1178: AND nvl(cust_party.SIC_CODE,'XXX') like nvl(P_SIC_CODE, nvl(cust_party.SIC_CODE,'XXX'))
1179:
1180: --sechawla : p_vendor_number -> value set 'OKL_VENDORS' -> returns PO_VENDORS.VENDOR_ID

Line 2074: HZ_PARTIES cust_party,

2070: OKC_STATUSES_TL status_tl,
2071: OKC_K_PARTY_ROLES_B cust_party_roles,
2072: fnd_lookup_values_vl lookup_book_class,
2073:
2074: HZ_PARTIES cust_party,
2075: HZ_CUST_ACCOUNTS cust_accounts,
2076: OKL_PRODUCTS pdt,
2077: OKL_PRODUCTS rpt_pdt,
2078: OKC_K_HEADERS_ALL_B vendor_chr,

Line 2208: --sechawla : P_CUSTOMER_NAME is hz_parties.party_id. value set: OKL_CUSTOMERS

2204:
2205: --there is no ID defined in the value set OKS_CUSTOMER_NUMBER. value is 'party_number'.
2206: AND cust_party.PARTY_NUMBER like nvl(P_CUSTOMER_NUMBER, cust_party.PARTY_NUMBER)
2207:
2208: --sechawla : P_CUSTOMER_NAME is hz_parties.party_id. value set: OKL_CUSTOMERS
2209: AND cust_party.party_id = nvl(P_CUSTOMER_NAME, cust_party.party_id)
2210: AND nvl(cust_party.SIC_CODE,'XXX') like nvl(P_SIC_CODE, nvl(cust_party.SIC_CODE,'XXX'))
2211:
2212: --sechawla : p_vendor_number -> value set 'OKL_VENDORS' -> returns PO_VENDORS.VENDOR_ID