DBA Data[Home] [Help]

APPS.PJM_TRANSFER_SPEC_CHARGES_PKG dependencies on PJM_ORG_PARAMETERS

Line 344: , PJM_Org_Parameters POP

340: AND ACA.Item_Dist_Id = AID2.Invoice_Distribution_Id
341: ) DIST
342: , PO_Distributions POD
343: , PA_Projects_ALL PAP
344: , PJM_Org_Parameters POP
345: WHERE DIST.Invoice_Id = INV.Invoice_Id
346: AND NVL(INV.Source, 'XX' ) <> 'Oracle Project Accounting'
347: AND POD.Destination_Type_Code IN ( 'INVENTORY' , 'SHOP FLOOR' )
348: AND POP.Organization_Id = POD.Destination_Organization_Id

Line 554: , PJM_Org_Parameters POP

550: AND ACA.Item_Dist_Id = AID2.Invoice_Distribution_Id
551: ) DIST
552: , PO_Distributions POD
553: , PA_Projects_ALL PAP
554: , PJM_Org_Parameters POP
555: WHERE DIST.Invoice_Id = INV.Invoice_Id
556: AND NVL(INV.Source, 'XX' ) <> 'Oracle Project Accounting'
557: AND POD.Destination_Type_Code IN ( 'INVENTORY' , 'SHOP FLOOR' )
558: AND POP.Organization_Id = POD.Destination_Organization_Id

Line 688: , pjm_org_parameters pop

684: nvl(ppp.misc_expenditure_type,
685: pop.misc_expenditure_type))
686: into l_expenditure_type
687: from pjm_project_parameters ppp
688: , pjm_org_parameters pop
689: where pop.organization_id = InvRec.Expenditure_Organization_Id
690: and ppp.organization_id (+) = pop.organization_id
691: and ppp.project_id (+) = InvRec.Project_Id;
692:

Line 774: from pjm_org_parameters

770: select NVL(pa_posting_flag,'N'),
771: NVL(pa_autoaccounting_flag,'N')
772: into l_blue_print_enabled_flag,
773: l_autoaccounting_flag
774: from pjm_org_parameters
775: where organization_id = InvRec.Expenditure_Organization_Id;
776:
777: If l_blue_print_enabled_flag = 'Y' then
778: If l_autoaccounting_flag = 'Y' then

Line 980: , pjm_org_parameters pop

976: nvl(ppp.misc_expenditure_type,
977: pop.misc_expenditure_type))
978: into l_expenditure_type
979: from pjm_project_parameters ppp
980: , pjm_org_parameters pop
981: where pop.organization_id = InvRec.Expenditure_Organization_Id
982: and ppp.organization_id (+) = pop.organization_id
983: and ppp.project_id (+) = InvRec.Project_Id;
984:

Line 1066: from pjm_org_parameters

1062: select NVL(pa_posting_flag,'N'),
1063: NVL(pa_autoaccounting_flag,'N')
1064: into l_blue_print_enabled_flag,
1065: l_autoaccounting_flag
1066: from pjm_org_parameters
1067: where organization_id = InvRec.Expenditure_Organization_Id;
1068:
1069: If l_blue_print_enabled_flag = 'Y' then
1070: If l_autoaccounting_flag = 'Y' then