DBA Data[Home] [Help]

APPS.JTF_RS_GRP_MEMBERSHIP_PUB dependencies on FND_LOOKUPS

Line 90: from fnd_lookups lkp, jtf_rs_roles_b rol

86: cursor role_type_dtl(l_role_id number)
87: is
88: select trunc(lkp.start_date_active),
89: trunc(lkp.end_date_active)
90: from fnd_lookups lkp, jtf_rs_roles_b rol
91: where rol.role_id = l_role_id
92: and lkp.lookup_type = 'JTF_RS_ROLE_TYPE'
93: and lkp.lookup_code = rol.role_type_code;
94:

Line 473: from fnd_lookups lkp, jtf_rs_roles_b rol

469: cursor role_type_dtl(l_role_id number)
470: is
471: select trunc(lkp.start_date_active),
472: trunc(lkp.end_date_active)
473: from fnd_lookups lkp, jtf_rs_roles_b rol
474: where rol.role_id = l_role_id
475: and lkp.lookup_type = 'JTF_RS_ROLE_TYPE'
476: and lkp.lookup_code = rol.role_type_code;
477: