APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on AMS_PARTY_MARKET_SEGMENTS

Line 663: FROM ams_party_market_segments seg

659: l_bg_is_parent_of_relcust NUMBER := 0;
660:
661: CURSOR csr_buy_group (cv_bg_party_id IN NUMBER, cv_cust_account_id IN NUMBER) IS
662: SELECT COUNT(seg.party_id)
663: FROM ams_party_market_segments seg
664: , hz_cust_accounts hca2
665: WHERE seg.market_qualifier_reference = cv_bg_party_id
666: AND hca2.party_id = seg.party_id
667: AND seg.market_qualifier_type = 'BG'

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

730:
731: ELSE
732: IF p_buy_group_party_id IS NOT NULL THEN
733: FND_DSQL.add_text(' IN (SELECT c2.cust_account_id ');
734: FND_DSQL.add_text(' FROM ams_party_market_segments sg, hz_cust_accounts c2 ');
735: FND_DSQL.add_text(' WHERE sg.market_qualifier_type = ''BG'' ');
736: FND_DSQL.add_text(' AND sg.party_id = c2.party_id ');
737: FND_DSQL.add_text(' AND sg.market_qualifier_reference = ');
738: FND_DSQL.add_bind(p_buy_group_party_id);

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

740: ELSE
741: -- Modified for Bugfix 5346249
742: FND_DSQL.add_text(' IN (SELECT cust2.cust_account_id FROM hz_cust_accounts cust2 ');
743: FND_DSQL.add_text(' WHERE cust2.party_id IN (SELECT seg.party_id from ');
744: FND_DSQL.add_text(' ams_party_market_segments seg ,hz_cust_accounts cust1 ');
745: FND_DSQL.add_text(' where seg.market_qualifier_type = ''BG'' ');
746: FND_DSQL.add_text(' and seg.market_qualifier_reference = cust1.party_id ');
747: FND_DSQL.add_text(' and cust1.cust_account_id = ');
748: IF p_related_cust_account_id IS NOT NULL THEN