APPS.CSC_RELATIONSHIP_PLANS_PVT dependencies on FND_LOOKUPS

Line 1529: from fnd_lookups

1525: )
1526: IS
1527: cursor group_in_lookup is
1528: select count(*)
1529: from fnd_lookups
1530: where lookup_code = p_PLAN_GROUP_CODE
1531: and sysdate between nvl(start_date_active, sysdate)
1532: and nvl(end_date_active, sysdate);
1533:

Line 1670: -- from fnd_lookups

1666: and lookup_code = P_END_USER_TYPE
1667: and sysdate between nvl(start_date_active, sysdate)
1668: and nvl(end_date_active, sysdate);
1669:
1670: -- from fnd_lookups
1671: l_rec_count NUMBER := 0;
1672: l_api_name varchar2(30) := 'Validate_End_User_Type';
1673: BEGIN
1674: -- Initialize message list if p_init_msg_list is set to TRUE.