APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on AMS_PARTY_MARKET_SEGMENTS

Line 588: FROM ams_party_market_segments seg

584: l_bg_is_parent_of_relcust NUMBER := 0;
585:
586: CURSOR csr_buy_group (cv_bg_party_id IN NUMBER, cv_cust_account_id IN NUMBER) IS
587: SELECT COUNT(seg.party_id)
588: FROM ams_party_market_segments seg
589: , hz_cust_accounts hca2
590: WHERE seg.market_qualifier_reference = cv_bg_party_id
591: AND hca2.party_id = seg.party_id
592: AND seg.market_qualifier_type = 'BG'

Line 659: FND_DSQL.add_text(' FROM ams_party_market_segments sg, hz_cust_accounts c2 ');

655:
656: ELSE
657: IF p_buy_group_party_id IS NOT NULL THEN
658: FND_DSQL.add_text(' IN (SELECT c2.cust_account_id ');
659: FND_DSQL.add_text(' FROM ams_party_market_segments sg, hz_cust_accounts c2 ');
660: FND_DSQL.add_text(' WHERE sg.market_qualifier_type = ''BG'' ');
661: FND_DSQL.add_text(' AND sg.party_id = c2.party_id ');
662: FND_DSQL.add_text(' AND sg.market_qualifier_reference = ');
663: FND_DSQL.add_bind(p_buy_group_party_id);

Line 669: FND_DSQL.add_text(' ams_party_market_segments seg ,hz_cust_accounts cust1 ');

665: ELSE
666: -- Modified for Bugfix 5346249
667: FND_DSQL.add_text(' IN (SELECT cust2.cust_account_id FROM hz_cust_accounts cust2 ');
668: FND_DSQL.add_text(' WHERE cust2.party_id IN (SELECT seg.party_id from ');
669: FND_DSQL.add_text(' ams_party_market_segments seg ,hz_cust_accounts cust1 ');
670: FND_DSQL.add_text(' where seg.market_qualifier_type = ''BG'' ');
671: FND_DSQL.add_text(' and seg.market_qualifier_reference = cust1.party_id ');
672: FND_DSQL.add_text(' and cust1.cust_account_id = ');
673: IF p_related_cust_account_id IS NOT NULL THEN