DBA Data[Home] [Help]

APPS.PJM_TRANSFER_IPV_PKG dependencies on PJM_ORG_PARAMETERS

Line 38: , pjm_org_parameters pop

34:
35: select nvl(ppp.ipv_expenditure_type, pop.ipv_expenditure_type)
36: into l_ipv_expenditure_type
37: from pjm_project_parameters ppp
38: , pjm_org_parameters pop
39: where pop.organization_id = X_Org_Id
40: and ppp.organization_id (+) = pop.organization_id
41: and ppp.project_id (+) = X_Project_Id;
42:

Line 58: , pjm_org_parameters pop

54:
55: select nvl(ppp.erv_expenditure_type, pop.erv_expenditure_type)
56: into l_erv_expenditure_type
57: from pjm_project_parameters ppp
58: , pjm_org_parameters pop
59: where pop.organization_id = X_Org_Id
60: and ppp.organization_id (+) = pop.organization_id
61: and ppp.project_id (+) = X_Project_Id;
62:

Line 239: PJM_Org_Parameters POP

235: AP_Invoice_Distributions DIST,
236: PO_Distributions POD,
237: PO_Lines POL,
238: PA_Projects_ALL PAP,
239: PJM_Org_Parameters POP
240: WHERE DIST.Pa_Addition_Flag IN ( 'N','S','A','B','C','D','E','I',
241: 'J','K','M','P','Q','V','X','W' )
242: AND DIST.Posted_Flag = 'Y'
243: AND DIST.LINE_TYPE_LOOKUP_CODE = 'ITEM'

Line 355: -- , PJM_Org_Parameters POP

351: -- NVL(l_Trx_Thru_Date, DIST.Accounting_Date)
352: -- AND exists (
353: -- Select 'X'
354: -- from Po_Distributions POD
355: -- , PJM_Org_Parameters POP
356: -- where DIST.Po_Distribution_Id = POD.Po_Distribution_ID
357: -- and POP.Organization_Id = POD.Destination_Organization_Id
358: -- and NVL(POD.Project_Id , POP.Common_Project_Id) =
359: -- NVL(X_Project_Id , NVL(POD.Project_Id , POP.Common_Project_Id))

Line 541: from pjm_org_parameters

537: select NVL(pa_posting_flag,'N'),
538: NVL(pa_autoaccounting_flag,'N')
539: into l_blue_print_enabled_flag,
540: l_autoaccounting_flag
541: from pjm_org_parameters
542: where organization_id = InvRec.Expenditure_Organization_Id;
543:
544: If l_blue_print_enabled_flag = 'Y' then
545: If l_autoaccounting_flag = 'Y' then