DBA Data[Home] [Help]

APPS.OKS_RENEW_CONTRACT_PVT dependencies on RA_RULES

Line 2607: FROM RA_RULES

2603: AND a.cle_id IS NULL;
2604:
2605: CURSOR c_chk_accounting_rule(l_id NUMBER) IS
2606: SELECT RULE_ID
2607: FROM RA_RULES
2608: WHERE TYPE IN ('A', 'ACC_DUR')
2609: AND RULE_ID = l_id;
2610:
2611: CURSOR c_chk_invoice_rule(l_id NUMBER) IS

Line 2613: FROM RA_RULES

2609: AND RULE_ID = l_id;
2610:
2611: CURSOR c_chk_invoice_rule(l_id NUMBER) IS
2612: SELECT RULE_ID
2613: FROM RA_RULES
2614: WHERE TYPE = 'I'
2615: AND RULE_ID = l_id;
2616:
2617: l_id_tbl num_tbl_type;