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 364: PJM_Org_Parameters POP,

360: AND PA_ADDITION_FLAG in ('E', 'M', 'N')
361: AND POSTED_FLAG = 'Y'
362: ) DIST,
363: PA_Projects_ALL PAP,
364: PJM_Org_Parameters POP,
365: PO_Distributions_All POD
366: WHERE INV.INVOICE_TYPE_LOOKUP_CODE <> 'EXPENSE REPORT'
367: AND POD.destination_type_code in ('INVENTORY', 'SHOP FLOOR')
368: AND DIST.Invoice_Id = INV.Invoice_Id

Line 435: PJM_Org_Parameters POP,

431: AND C.charge_applicable_to_dist_id = P.invoice_distribution_id
432: AND (P.charge_applicable_to_dist_id IS NOT NULL OR C.LINE_TYPE_LOOKUP_CODE IN ('FREIGHT','MISCELLANEOUS')) -- bugfix 7482789
433: ) DIST,
434: PA_Projects_ALL PAP,
435: PJM_Org_Parameters POP,
436: PO_Distributions_All POD
437: WHERE INV.INVOICE_TYPE_LOOKUP_CODE <> 'EXPENSE REPORT'
438: AND POD.destination_type_code in ('INVENTORY', 'SHOP FLOOR')
439: AND DIST.Invoice_Id = INV.Invoice_Id

Line 504: PJM_Org_Parameters POP,

500: AND PA_ADDITION_FLAG in ('E', 'M', 'N')
501: AND POSTED_FLAG = 'Y'
502: ) DIST,
503: PA_Projects_ALL PAP,
504: PJM_Org_Parameters POP,
505: PO_Distributions_All POD
506: WHERE INV.INVOICE_TYPE_LOOKUP_CODE <> 'EXPENSE REPORT'
507: AND POD.destination_type_code in ('INVENTORY', 'SHOP FLOOR')
508: AND DIST.Invoice_Id = INV.Invoice_Id

Line 576: PJM_Org_Parameters POP,

572: AND C.charge_applicable_to_dist_id = P.invoice_distribution_id
573: AND (P.charge_applicable_to_dist_id IS NOT NULL OR C.LINE_TYPE_LOOKUP_CODE IN ('FREIGHT','MISCELLANEOUS')) -- bugfix 7482789
574: ) DIST,
575: PA_Projects_ALL PAP,
576: PJM_Org_Parameters POP,
577: PO_Distributions_All POD
578: WHERE INV.INVOICE_TYPE_LOOKUP_CODE <> 'EXPENSE REPORT'
579: AND POD.destination_type_code in ('INVENTORY', 'SHOP FLOOR')
580: AND DIST.Invoice_Id = INV.Invoice_Id

Line 836: from pjm_org_parameters

832: select NVL(pa_posting_flag,'N'),
833: NVL(pa_autoaccounting_flag,'N')
834: into l_blue_print_enabled_flag,
835: l_autoaccounting_flag
836: from pjm_org_parameters
837: where organization_id = InvRec.Expenditure_Organization_Id;
838:
839: if PoRec.destination_type_code = 'INVENTORY' then -- bug 4184314
840: l_linkage := 'INV';

Line 1204: from pjm_org_parameters

1200: select NVL(pa_posting_flag,'N'),
1201: NVL(pa_autoaccounting_flag,'N')
1202: into l_blue_print_enabled_flag,
1203: l_autoaccounting_flag
1204: from pjm_org_parameters
1205: where organization_id = InvRec.Expenditure_Organization_Id;
1206:
1207: if PoRec.destination_type_code = 'INVENTORY' then -- bug 4184314
1208: l_linkage := 'INV';

Line 1579: from pjm_org_parameters

1575: select NVL(pa_posting_flag,'N'),
1576: NVL(pa_autoaccounting_flag,'N')
1577: into l_blue_print_enabled_flag,
1578: l_autoaccounting_flag
1579: from pjm_org_parameters
1580: where organization_id = InvRec.Expenditure_Organization_Id;
1581:
1582: if PoRec.destination_type_code = 'INVENTORY' then
1583: l_linkage := 'INV';

Line 1944: from pjm_org_parameters

1940: select NVL(pa_posting_flag,'N'),
1941: NVL(pa_autoaccounting_flag,'N')
1942: into l_blue_print_enabled_flag,
1943: l_autoaccounting_flag
1944: from pjm_org_parameters
1945: where organization_id = InvRec.Expenditure_Organization_Id;
1946:
1947: if PoRec.destination_type_code = 'INVENTORY' then
1948: l_linkage := 'INV';