DBA Data[Home] [Help]

APPS.OKL_ARINTF_PVT dependencies on OKC_RULE_GROUPS_B

Line 115: Okc_rule_groups_B rgp

111:
112: CURSOR cust_line_pmth_csr ( p_khr_id NUMBER, p_kle_id NUMBER ) IS
113: SELECT object1_id1
114: FROM OKC_RULES_B rul,
115: Okc_rule_groups_B rgp
116: WHERE rul.rgp_id = rgp.id AND
117: rgp.rgd_code = 'LABILL' AND
118: rgp.cle_id = p_kle_id AND
119: rul.rule_information_category = 'LAPMTH' AND

Line 127: , Okc_rule_groups_B rgp

123: FROM okc_k_lines_b cle
124: , okc_k_items_v item
125: , okc_k_lines_b linked_asset
126: , OKC_RULES_B rul
127: , Okc_rule_groups_B rgp
128: WHERE cle.dnz_chr_id = p_khr_id AND
129: cle.id = p_kle_id AND
130: cle.chr_id IS NULL AND
131: cle.id = item.cle_id AND

Line 155: Okc_rule_groups_B rgp

151:
152: CURSOR cust_line_bank_csr ( p_khr_id NUMBER, p_kle_id NUMBER ) IS
153: SELECT object1_id1
154: FROM OKC_RULES_B rul,
155: Okc_rule_groups_B rgp
156: WHERE rul.rgp_id = rgp.id AND
157: rgp.cle_id = p_kle_id AND
158: rgp.rgd_code = 'LABILL' AND
159: rul.rule_information_category = 'LABACC' AND

Line 167: , Okc_rule_groups_B rgp

163: FROM okc_k_lines_b cle
164: , okc_k_items_v item
165: , okc_k_lines_b linked_asset
166: , OKC_RULES_B rul
167: , Okc_rule_groups_B rgp
168: WHERE cle.dnz_chr_id = p_khr_id AND
169: cle.id = p_kle_id AND
170: cle.chr_id IS NULL AND
171: cle.id = item.cle_id AND

Line 804: Okc_rule_groups_B rgp,

800: -- on a contract
801: CURSOR c_vendor_bank_csr ( cp_khr_id NUMBER, cp_cust_acct_id NUMBER) IS
802: SELECT rul.object1_id1
803: FROM OKC_RULES_B rul,
804: Okc_rule_groups_B rgp,
805: Okc_rg_party_roles rpr,
806: Okc_k_party_roles_b cpl
807: WHERE rul.rgp_id = rgp.id AND
808: rgp.rgd_code = 'LAVENB' AND

Line 919: Okc_rule_groups_B rgp,

915: -- on a contract
916: CURSOR c_ven_payment_method(p_khr_id NUMBER, p_cust_acct_id NUMBER) IS
917: SELECT rul.object1_id1
918: FROM OKC_RULES_B rul,
919: Okc_rule_groups_B rgp,
920: Okc_rg_party_roles rpr,
921: Okc_k_party_roles_b cpl
922: WHERE rul.rgp_id = rgp.id AND
923: rgp.rgd_code = 'LAVENB' AND

Line 1564: Okc_rule_groups_B rgp

1560: -- Fetch the Contract Level Bank Id
1561: CURSOR cust_bank_csr ( cp_khr_id NUMBER ) IS
1562: SELECT object1_id1
1563: FROM OKC_RULES_B rul,
1564: Okc_rule_groups_B rgp
1565: WHERE rul.rgp_id = rgp.id AND
1566: rgp.rgd_code = 'LABILL' AND
1567: rgp.dnz_chr_id = rgp.chr_id AND
1568: rul.rule_information_category = 'LABACC' AND