APPS.PN_LEASE_UTILS dependencies on HZ_PARTIES

Line 1675: FROM hz_parties hp, hz_cust_accounts hca

1671:
1672: CURSOR c_tenancy_customer_name
1673: IS
1674: SELECT hca.cust_account_id
1675: FROM hz_parties hp, hz_cust_accounts hca
1676: WHERE hp.party_id = hca.party_id
1677: AND hca.status = 'A'
1678: AND hp.party_name = p_customer_name;
1679:

Line 1683: FROM hz_parties hp, hz_cust_accounts hca

1679:
1680: CURSOR c_tenancy_customer_id
1681: IS
1682: SELECT hca.cust_account_id
1683: FROM hz_parties hp, hz_cust_accounts hca
1684: WHERE hp.party_id = hca.party_id
1685: AND hca.status = 'A'
1686: AND hca.cust_account_id = x_customer_id;
1687:

Line 1841: FROM hz_parties hp

1837:
1838: CURSOR cur_customer
1839: IS
1840: SELECT hca.cust_account_id
1841: FROM hz_parties hp
1842: , hz_cust_accounts hca
1843: WHERE hp.party_id = hca.party_id
1844: AND hca.status = 'A'
1845: AND party_name = p_customer_name;

Line 1850: FROM hz_parties hp

1846:
1847: CURSOR cur_customer_id
1848: IS
1849: SELECT hca.cust_account_id
1850: FROM hz_parties hp
1851: , hz_cust_accounts hca
1852: WHERE hp.party_id = hca.party_id
1853: AND hca.status = 'A'
1854: AND hca.cust_account_id = x_customer_id;

Line 2315: FROM hz_parties hp, hz_cust_accounts hca

2311:
2312: CURSOR c_customer
2313: IS
2314: SELECT hca.cust_account_id
2315: FROM hz_parties hp, hz_cust_accounts hca
2316: WHERE hp.party_id = hca.party_id
2317: AND hca.status = 'A'
2318: AND hp.party_name = p_customer_name;
2319:

Line 2323: FROM hz_parties hp, hz_cust_accounts hca

2319:
2320: CURSOR c_customer_id
2321: IS
2322: SELECT hca.cust_account_id
2323: FROM hz_parties hp, hz_cust_accounts hca
2324: WHERE hp.party_id = hca.party_id
2325: AND hca.status = 'A'
2326: AND hca.cust_account_id = x_customer_id;
2327: BEGIN