APPS.CN_PMTPLAN_PVT dependencies on CN_INTERVAL_TYPES

Line 132: FROM cn_interval_types

128: and org_id = p_PmtPlan_rec.org_id;
129:
130: CURSOR get_pay_interval_type_id IS
131: SELECT interval_type_id
132: FROM cn_interval_types
133: WHERE name = p_pmtplan_rec.pay_interval_type_name
134: and org_id = p_PmtPlan_rec.org_id;
135:
136: BEGIN

Line 444: FROM cn_interval_types

440: and org_id = p_PmtPlan_rec.org_id;
441:
442: CURSOR get_pay_interval_type_id IS
443: SELECT interval_type_id
444: FROM cn_interval_types
445: WHERE name = p_pmtplan_rec.pay_interval_type_name
446: and org_id = p_PmtPlan_rec.org_id;
447:
448:

Line 451: FROM cn_interval_types

447:
448:
449: CURSOR get_rec_interval_type_id IS
450: SELECT interval_type_id
451: FROM cn_interval_types
452: WHERE name = p_pmtplan_rec.recoverable_interval_type
453: and org_id = p_PmtPlan_rec.org_id;
454:
455: BEGIN

Line 778: FROM cn_interval_types

774:
775:
776: CURSOR get_pay_interval_type_id IS
777: SELECT interval_type_id
778: FROM cn_interval_types
779: WHERE name = p_pmtplan_rec.pay_interval_type_name
780: AND org_id = p_PmtPlan_rec.org_id;
781:
782: CURSOR get_pmt_plan (p_pmt_plan_id NUMBER) IS

Line 801: FROM cn_interval_types

797: AND org_id = p_PmtPlan_rec.org_id;
798:
799: CURSOR get_interval_type_curs ( l_interval_type_id Varchar2 ) IS
800: SELECT name
801: FROM cn_interval_types
802: WHERE interval_type_id = l_interval_type_id
803: AND org_id = p_PmtPlan_rec.org_id;
804:
805: CURSOR l_ovn_csr IS

Line 815: FROM cn_interval_types

811: l_object_version_number NUMBER;
812:
813: CURSOR get_rec_interval_type_curs ( l_rec_interval_type_id NUMBER ) IS
814: SELECT name
815: FROM cn_interval_types
816: WHERE interval_type_id = l_rec_interval_type_id
817: AND org_id = p_PmtPlan_rec.org_id;
818:
819:

Line 822: FROM cn_interval_types

818:
819:
820: CURSOR get_rec_interval_type_id ( l_rec_interval_type VARCHAR2 ) IS
821: SELECT interval_type_id
822: FROM cn_interval_types
823: WHERE name = l_rec_interval_type
824: AND org_id = p_PmtPlan_rec.org_id;
825:
826: BEGIN