DBA Data[Home] [Help]

APPS.CN_SFP_ROLE_UTIL_PVT dependencies on CN_RATE_SCHEDULES_ALL

Line 39: SELECT NVL(ORG_ID,-99) INTO l_temp_org FROM CN_RATE_SCHEDULES_ALL WHERE rate_schedule_id = l_rate_sch_id;

35: l_seas_id := eachq.SEAS_SCHEDULE_ID;
36:
37: -- Start doing the cheque for Rate Schedules
38: IF l_rate_sch_id IS NOT NULL THEN
39: SELECT NVL(ORG_ID,-99) INTO l_temp_org FROM CN_RATE_SCHEDULES_ALL WHERE rate_schedule_id = l_rate_sch_id;
40: IF l_temp_org <> l_org_id THEN
41: l_rate_sch_pass := 'N';
42: EXIT;
43: END IF;