DBA Data[Home] [Help]

APPS.PJM_PROJECT_PARAM_PUB dependencies on FND_COMMON_LOOKUPS

Line 894: FROM fnd_common_lookups

890: l_api_version CONSTANT NUMBER := 1.0;
891:
892: CURSOR pg IS
893: SELECT lookup_code
894: FROM fnd_common_lookups
895: WHERE application_id = 704
896: AND lookup_type = 'PLANNING_GROUP'
897: AND lookup_code = P_planning_group
898: AND sysdate BETWEEN nvl( start_date_active , sysdate - 1)