APPS.OZF_SUPP_TRADE_PROFILE_PUB dependencies on OZF_SUPP_TRD_PRFLS_ALL

Line 1623: FROM ozf_supp_trd_prfls_all

1619: DECODE(p_supp_trade_profile_rec.auto_debit ,FND_API.g_miss_char, auto_debit,p_supp_trade_profile_rec.auto_debit) auto_debit,
1620: DECODE(p_supp_trade_profile_rec.days_before_claiming_debit , FND_API.g_miss_num, days_before_claiming_debit,p_supp_trade_profile_rec.days_before_claiming_debit) days_before_claiming_debit,
1621: DECODE(p_supp_trade_profile_rec.ssd_imd_claim_flag ,FND_API.g_miss_char, ssd_imd_claim_flag,p_supp_trade_profile_rec.ssd_imd_claim_flag) ssd_imd_claim_flag,
1622: security_group_id
1623: FROM ozf_supp_trd_prfls_all
1624: WHERE supp_trade_profile_id = p_supp_trade_profile_rec.supp_trade_profile_id ;
1625:
1626:
1627: l_ref_supp_trade_profile_rec c_trd_prfl%ROWTYPE;

Line 1987: FROM ozf_supp_trd_prfls_all

1983:
1984:
1985: -- Existence checking for Supplier + Supplier site combination
1986: SELECT COUNT(*) INTO l_supp_site_comb_count
1987: FROM ozf_supp_trd_prfls_all
1988: WHERE supplier_id = p_supp_trade_profile_rec.supplier_id
1989: AND supplier_site_id = p_supp_trade_profile_rec.supplier_site_id ;
1990:
1991: IF ( l_supp_site_comb_count<>0 ) THEN

Line 2700: select ORG_ID FROM ozf_supp_trd_prfls_all

2696: l_exec_err VARCHAR2(1) := 'N' ;
2697:
2698: CURSOR csr_supp_rec(cv_supp_trade_profile_id NUMBER)
2699: IS
2700: select ORG_ID FROM ozf_supp_trd_prfls_all
2701: WHERE supp_trade_profile_id= cv_supp_trade_profile_id ;
2702:
2703: BEGIN
2704:

Line 3193: SELECT org_id FROM ozf_supp_trd_prfls_all

3189:
3190: l_exec_err VARCHAR2(1) := 'N' ;
3191:
3192: CURSOR c_sel_trd_org IS
3193: SELECT org_id FROM ozf_supp_trd_prfls_all
3194: WHERE supp_trade_profile_id = p_trade_prf_id ;
3195:
3196: BEGIN
3197: