APPS.OKL_PAYMENT_APPLICATION_PVT dependencies on OKC_RULE_GROUPS_V

Line 83: okc_rule_groups_v rg,

79: CURSOR lrule_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
80: p_strm_id OKC_RULES_V.OBJECT1_ID1%TYPE) IS
81: SELECT 'Y'
82: FROM okc_rules_v rule,
83: okc_rule_groups_v rg,
84: okc_k_lines_b cle,
85: okc_line_styles_b lsb
86: WHERE rule.dnz_chr_id = p_chr_id
87: AND rule_information_category IN ('LASLH','LASLL')

Line 170: okc_rule_groups_v rg,

166: p_strm_id OKC_RULES_V.OBJECT1_ID1%TYPE) IS
167:
168: SELECT 'Y'
169: FROM okc_rules_v rule,
170: okc_rule_groups_v rg,
171: okc_k_lines_b cleb, -- Top Line
172: okc_k_lines_b cle, -- Sub Line
173: okc_line_styles_b lsb
174: WHERE rule.dnz_chr_id = p_chr_id

Line 310: -- FUNCTION get_rec for: OKC_RULE_GROUPS_V

306: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
307: l_api_name CONSTANT VARCHAR2(30) := 'GET_CONTRACT_RULE_GROUP';
308: l_api_version CONSTANT NUMBER := 1.0;
309: ---------------------------------------------------------------------------
310: -- FUNCTION get_rec for: OKC_RULE_GROUPS_V
311: ---------------------------------------------------------------------------
312: FUNCTION get_rgpv_tab (
313: p_chr_id IN NUMBER,
314: p_cle_id IN NUMBER,

Line 357: FROM Okc_Rule_Groups_V rg,

353: rg.CREATION_DATE,
354: rg.LAST_UPDATED_BY,
355: rg.LAST_UPDATE_DATE,
356: rg.LAST_UPDATE_LOGIN
357: FROM Okc_Rule_Groups_V rg,
358: Okc_Rules_V rule
359: WHERE NVL(rg.chr_id,-9999) = p_chr_id
360: --AND NVL(rg.cle_id,-9999) = p_cle_id
361: --AND rg.dnz_chr_id = DECODE(p_chr_id,-9999,rg.dnz_chr_id,p_dnz_chr_id)

Line 497: -- FUNCTION get_rec for: OKC_RULE_GROUPS_V

493: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
494: l_api_name CONSTANT VARCHAR2(30) := 'GET_RO_FEE_TOPLN_RG';
495: l_api_version CONSTANT NUMBER := 1.0;
496: ---------------------------------------------------------------------------
497: -- FUNCTION get_rec for: OKC_RULE_GROUPS_V
498: ---------------------------------------------------------------------------
499: FUNCTION get_rgpv_tab (
500: p_chr_id IN NUMBER,
501: p_cle_id IN NUMBER,

Line 543: FROM Okc_Rule_Groups_V rg,

539: rg.CREATION_DATE,
540: rg.LAST_UPDATED_BY,
541: rg.LAST_UPDATE_DATE,
542: rg.LAST_UPDATE_LOGIN
543: FROM Okc_Rule_Groups_V rg,
544: Okc_Rules_V rule
545: WHERE rg.dnz_chr_id = p_chr_id
546: AND rg.cle_id = p_cle_id
547: AND rule.object1_id1 = to_char(p_strm_id)

Line 1144: FROM okc_rule_groups_v

1140:
1141: CURSOR rg_csr (p_chr_id NUMBER,
1142: p_cle_id NUMBER) IS
1143: SELECT ID
1144: FROM okc_rule_groups_v
1145: WHERE dnz_chr_id = p_chr_id
1146: AND cle_id = p_cle_id
1147: AND rgd_code = 'LALEVL';
1148:

Line 1572: FROM okc_rule_groups_v rg

1568:
1569: CURSOR rg_del_csr (p_chr_id NUMBER,
1570: p_rgp_id NUMBER) IS
1571: SELECT 'Y'
1572: FROM okc_rule_groups_v rg
1573: WHERE NOT EXISTS (SELECT 'Y'
1574: FROM okc_rules_v rule
1575: WHERE rule.rgp_id = rg.id
1576: )

Line 1886: FROM okc_rule_groups_v rg

1882:
1883: CURSOR rg_del_csr (p_chr_id NUMBER,
1884: p_rgp_id NUMBER) IS
1885: SELECT 'Y'
1886: FROM okc_rule_groups_v rg
1887: WHERE NOT EXISTS (SELECT 'Y'
1888: FROM okc_rules_v rule
1889: WHERE rule.rgp_id = rg.id
1890: )

Line 2226: FROM okc_rule_groups_v rg

2222:
2223: CURSOR rg_del_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2224: p_rgp_id NUMBER) IS
2225: SELECT 'Y'
2226: FROM okc_rule_groups_v rg
2227: WHERE NOT EXISTS (SELECT 'Y'
2228: FROM okc_rules_v rule
2229: WHERE rule.rgp_id = rg.id
2230: )

Line 2561: FROM okc_rule_groups_v rg

2557:
2558: CURSOR rg_del_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2559: p_rgp_id NUMBER) IS
2560: SELECT 'Y'
2561: FROM okc_rule_groups_v rg
2562: WHERE NOT EXISTS (SELECT 'Y'
2563: FROM okc_rules_v rule
2564: WHERE rule.rgp_id = rg.id
2565: )

Line 2859: p_rgp_id IN OKC_RULE_GROUPS_V.ID%TYPE,

2855: x_return_status OUT NOCOPY VARCHAR2,
2856: x_msg_count OUT NOCOPY NUMBER,
2857: x_msg_data OUT NOCOPY VARCHAR2,
2858: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2859: p_rgp_id IN OKC_RULE_GROUPS_V.ID%TYPE,
2860: p_rule_id IN OKC_RULES_V.ID%TYPE
2861: ) IS
2862: l_api_name VARCHAR2(35) := 'delete_payment';
2863: l_proc_name VARCHAR2(35) := 'DELETE_PAYMENT';

Line 2867: p_rgp_id OKC_RULE_GROUPS_V.ID%TYPE,

2863: l_proc_name VARCHAR2(35) := 'DELETE_PAYMENT';
2864: l_api_version CONSTANT NUMBER := 1;
2865:
2866: CURSOR sll_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2867: p_rgp_id OKC_RULE_GROUPS_V.ID%TYPE,
2868: p_rule_id OKC_RULES_V.ID%TYPE) IS
2869: SELECT id
2870: FROM okc_rules_v
2871: WHERE dnz_chr_id = p_chr_id

Line 2877: p_rgp_id OKC_RULE_GROUPS_V.ID%TYPE) IS

2873: AND object2_id1 = p_rule_id
2874: AND rule_information_category = 'LASLL';
2875:
2876: CURSOR rgp_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2877: p_rgp_id OKC_RULE_GROUPS_V.ID%TYPE) IS
2878: SELECT 'Y'
2879: FROM okc_rules_v
2880: WHERE dnz_chr_id = p_chr_id
2881: AND rgp_id = p_rgp_id;