DBA Data[Home] [Help]

APPS.OZF_FUNDS_PUB dependencies on HZ_PARTIES

Line 1435: FROM ams_party_market_segments ams, hz_parties hz

1431: AND lookup_code = p_segment;
1432:
1433: CURSOR c_segment_buyer (p_segment_id IN NUMBER) IS
1434: SELECT 1
1435: FROM ams_party_market_segments ams, hz_parties hz
1436: WHERE ams.market_qualifier_type = 'BG'
1437: AND ams.market_qualifier_reference = hz.party_id
1438: AND ams.market_qualifier_reference = ams.party_id
1439: AND EXISTS

Line 1454: FROM oe_invoice_to_orgs_v oito,hz_cust_accounts cust_acct,hz_parties party

1450: WHERE customer_id = p_segment_id;
1451:
1452: CURSOR c_segment_billto (p_segment_id IN NUMBER) IS
1453: SELECT 1
1454: FROM oe_invoice_to_orgs_v oito,hz_cust_accounts cust_acct,hz_parties party
1455: WHERE cust_acct.party_id = party.party_id
1456: AND oito.customer_id = cust_acct.cust_account_id
1457: AND oito.organization_id = p_segment_id;
1458: