DBA Data[Home] [Help]

APPS.CN_SRP_QUOTA_ASSIGNS_PKG dependencies on CN_SRP_PAYEE_ASSIGNS

Line 912: FROM cn_srp_payee_assigns

908:
909: CURSOR get_payee_del_strdt_cur(p_srp_quota_assign_id NUMBER,
910: p_quota_id NUMBER) IS
911: SELECT srp_payee_assign_id
912: FROM cn_srp_payee_assigns
913: WHERE srp_quota_assign_id = p_srp_quota_assign_id
914: AND quota_id = p_quota_id ;
915:
916: BEGIN

Line 932: cn_srp_payee_assigns_pkg.delete_record

928: FOR p IN get_payee_del_strdt_cur
929: (recinfo.srp_quota_assign_id,
930: recinfo.quota_id) LOOP
931:
932: cn_srp_payee_assigns_pkg.delete_record
933: (p_srp_payee_assign_id => p.srp_payee_assign_id);
934: END LOOP;
935:
936: -- Delete cn_srp_rollover_quotas records

Line 963: cn_srp_payee_assigns_pkg.delete_record

959: FOR p IN get_payee_del_strdt_cur
960: (recinfo.srp_quota_assign_id,
961: recinfo.quota_id) LOOP
962:
963: cn_srp_payee_assigns_pkg.delete_record
964: (p_srp_payee_assign_id => p.srp_payee_assign_id);
965:
966: END LOOP;
967: