DBA Data[Home] [Help]

APPS.OKL_VARIABLE_INT_UTIL_PVT dependencies on OKC_RULES_B

Line 1832: FROM okc_rules_b sll,

1828: WHERE id = cp_khr_id;
1829:
1830: CURSOR l_payment_freq_csr(cp_khr_id IN NUMBER) IS
1831: SELECT DECODE(sll.object1_id1,'M',1,'Q',3,'S',6,'A',12) pay_freq
1832: FROM okc_rules_b sll,
1833: okc_rules_b slh,
1834: okl_strm_type_v styp,
1835: okc_rule_groups_b rgp
1836: WHERE TO_NUMBER(sll.object2_id1) = slh.id

Line 1833: okc_rules_b slh,

1829:
1830: CURSOR l_payment_freq_csr(cp_khr_id IN NUMBER) IS
1831: SELECT DECODE(sll.object1_id1,'M',1,'Q',3,'S',6,'A',12) pay_freq
1832: FROM okc_rules_b sll,
1833: okc_rules_b slh,
1834: okl_strm_type_v styp,
1835: okc_rule_groups_b rgp
1836: WHERE TO_NUMBER(sll.object2_id1) = slh.id
1837: AND sll.rule_information_category = 'LASLL'