APPS.PJM_TRANSFER_CHARGES_PKG dependencies on PJM_ORG_PARAMETERS

Line 50: , pjm_org_parameters pop

46:
47: select nvl(ppp.ipv_expenditure_type, pop.ipv_expenditure_type)
48: into l_ipv_expenditure_type
49: from pjm_project_parameters ppp
50: , pjm_org_parameters pop
51: where pop.organization_id = X_Org_Id
52: and ppp.organization_id (+) = pop.organization_id
53: and ppp.project_id (+) = X_Project_Id;
54:

Line 70: , pjm_org_parameters pop

66:
67: select nvl(ppp.erv_expenditure_type, pop.erv_expenditure_type)
68: into l_erv_expenditure_type
69: from pjm_project_parameters ppp
70: , pjm_org_parameters pop
71: where pop.organization_id = X_Org_Id
72: and ppp.organization_id (+) = pop.organization_id
73: and ppp.project_id (+) = X_Project_Id;
74:

Line 123: , pjm_org_parameters pop

119: pop.tax_expenditure_type),
120: null)
121: into l_expenditure_type
122: from pjm_project_parameters ppp
123: , pjm_org_parameters pop
124: where pop.organization_id = X_Org_ID
125: and ppp.organization_id (+) = pop.organization_id
126: and ppp.project_id (+) = X_Project_Id;
127:

Line 382: PJM_Org_Parameters POP,

378: AND PA_ADDITION_FLAG in ('E', 'M', 'N')
379: AND POSTED_FLAG = 'Y'
380: ) DIST,
381: PA_Projects_ALL PAP,
382: PJM_Org_Parameters POP,
383: PO_Distributions_All POD
384: WHERE INV.INVOICE_TYPE_LOOKUP_CODE <> 'EXPENSE REPORT'
385: AND POD.destination_type_code in ('INVENTORY', 'SHOP FLOOR')
386: AND DIST.Invoice_Id = INV.Invoice_Id

Line 452: PJM_Org_Parameters POP,

448: AND C.charge_applicable_to_dist_id = P.invoice_distribution_id
449: AND (P.charge_applicable_to_dist_id IS NOT NULL OR C.LINE_TYPE_LOOKUP_CODE IN ('FREIGHT','MISCELLANEOUS')) -- bugfix 7482789
450: ) DIST,
451: PA_Projects_ALL PAP,
452: PJM_Org_Parameters POP,
453: PO_Distributions_All POD
454: WHERE INV.INVOICE_TYPE_LOOKUP_CODE <> 'EXPENSE REPORT'
455: AND POD.destination_type_code in ('INVENTORY', 'SHOP FLOOR')
456: AND DIST.Invoice_Id = INV.Invoice_Id

Line 517: PJM_Org_Parameters POP,

513: AND PA_ADDITION_FLAG in ('E', 'M', 'N')
514: AND POSTED_FLAG = 'Y'
515: ) DIST,
516: PA_Projects_ALL PAP,
517: PJM_Org_Parameters POP,
518: PO_Distributions_All POD
519: WHERE INV.INVOICE_TYPE_LOOKUP_CODE <> 'EXPENSE REPORT'
520: AND POD.destination_type_code in ('INVENTORY', 'SHOP FLOOR')
521: AND DIST.Invoice_Id = INV.Invoice_Id

Line 589: PJM_Org_Parameters POP,

585: AND C.charge_applicable_to_dist_id = P.invoice_distribution_id
586: AND (P.charge_applicable_to_dist_id IS NOT NULL OR C.LINE_TYPE_LOOKUP_CODE IN ('FREIGHT','MISCELLANEOUS')) -- bugfix 7482789
587: ) DIST,
588: PA_Projects_ALL PAP,
589: PJM_Org_Parameters POP,
590: PO_Distributions_All POD
591: WHERE INV.INVOICE_TYPE_LOOKUP_CODE <> 'EXPENSE REPORT'
592: AND POD.destination_type_code in ('INVENTORY', 'SHOP FLOOR')
593: AND DIST.Invoice_Id = INV.Invoice_Id

Line 908: from pjm_org_parameters

904: select NVL(pa_posting_flag,'N'),
905: NVL(pa_autoaccounting_flag,'N')
906: into l_blue_print_enabled_flag,
907: l_autoaccounting_flag
908: from pjm_org_parameters
909: where organization_id = InvRec.Expenditure_Organization_Id;
910:
911: l_system_reference := NULL;
912: if PoRec.destination_type_code = 'INVENTORY' then -- bug 4184314

Line 1342: from pjm_org_parameters

1338: select NVL(pa_posting_flag,'N'),
1339: NVL(pa_autoaccounting_flag,'N')
1340: into l_blue_print_enabled_flag,
1341: l_autoaccounting_flag
1342: from pjm_org_parameters
1343: where organization_id = InvRec.Expenditure_Organization_Id;
1344:
1345: l_system_reference := NULL;
1346: if PoRec.destination_type_code = 'INVENTORY' then -- bug 4184314

Line 1781: from pjm_org_parameters

1777: select NVL(pa_posting_flag,'N'),
1778: NVL(pa_autoaccounting_flag,'N')
1779: into l_blue_print_enabled_flag,
1780: l_autoaccounting_flag
1781: from pjm_org_parameters
1782: where organization_id = InvRec.Expenditure_Organization_Id;
1783:
1784: l_system_reference := NULL;
1785: if PoRec.destination_type_code = 'INVENTORY' then

Line 2209: from pjm_org_parameters

2205: select NVL(pa_posting_flag,'N'),
2206: NVL(pa_autoaccounting_flag,'N')
2207: into l_blue_print_enabled_flag,
2208: l_autoaccounting_flag
2209: from pjm_org_parameters
2210: where organization_id = InvRec.Expenditure_Organization_Id;
2211:
2212: l_system_reference := NULL;
2213: if PoRec.destination_type_code = 'INVENTORY' then