DBA Data[Home] [Help]

APPS.PJM_COMMON_PROJ_PKG dependencies on PJM_ORG_PARAMETERS

Line 14: from pjm_org_parameters

10: Begin
11:
12: Select Common_Project_Id
13: into l_common_proj_id
14: from pjm_org_parameters
15: where Organization_Id = X_Org_Id;
16:
17: return (l_common_proj_id);
18:

Line 42: from pjm_org_parameters

38: ) IS
39:
40: Cursor c is
41: select organization_id , common_project_id
42: from pjm_org_parameters
43: where organization_id = nvl(X_Org_Id , organization_id)
44: and common_project_id is not null
45: order by organization_id,common_project_id /*Bug 6972181 (FP of 6900015): Added order by clause*/
46: FOR UPDATE of organization_id; /*Bug 8668526 (one-off for 7198823) */