DBA Data[Home] [Help]

APPS.CN_SRP_ROLLOVER_QUOTA_PVT dependencies on CN_SRP_QUOTA_ASSIGNS

Line 43: l_customized_flag cn_srp_quota_assigns.customized_flag%type;

39: l_loading_status varchar2(50);
40:
41: l_srp_rollover_quota_id NUMBER := NULL;
42: l_rollover NUMBER := NULL;
43: l_customized_flag cn_srp_quota_assigns.customized_flag%type;
44:
45:
46: l_attribute_category cn_srp_rollover_quotas.attribute_category%TYPE;
47: l_attribute1 cn_srp_rollover_quotas.attribute1%TYPE;

Line 255: from cn_srp_quota_assigns

251: IF l_rollover <> l_old_srp_rollover_quota.rollover THEN
252:
253: select customized_flag
254: into l_customized_flag
255: from cn_srp_quota_assigns
256: where srp_quota_assign_id = p_srp_rollover_quota.srp_quota_assign_id;
257:
258:
259: IF l_customized_flag = 'Y' THEN