DBA Data[Home] [Help]

APPS.PA_PROJECT_PVT dependencies on FND_LOOKUP_VALUES

Line 10700: fnd_lookup_values lookup

10696: CURSOR l_project_role_types_csr (p_role_type IN VARCHAR2)
10697: IS
10698: SELECT 'x' FROM
10699: pa_project_role_types_vl role,
10700: fnd_lookup_values lookup
10701: WHERE role.project_role_type = p_role_type
10702: and lookup.lookup_type='PA_ORGANIZATION_ROLE_CLASSES'
10703: and role.role_party_class=lookup.lookup_code
10704: and lookup.language=role.language;

Line 10846: fnd_lookup_values lookup

10842: --Bug#10124493 - project_role_type should be taken from pa_project_role_types_vl view
10843: Select role.project_role_id
10844: Into v_project_role_id
10845: From pa_project_role_types_vl role,
10846: fnd_lookup_values lookup
10847: WHERE role.project_role_type = p_org_roles(i).project_role_type
10848: and lookup.lookup_type='PA_ORGANIZATION_ROLE_CLASSES'
10849: and role.role_party_class=lookup.lookup_code
10850: and lookup.language=role.language;