DBA Data[Home] [Help]

APPS.PJM_TRANSFER_CHARGES_PKG dependencies on HR_ORGANIZATION_UNITS

Line 1080: , HR_Organization_Units ORG

1076: , l_system_reference
1077: FROM
1078: AP_Invoice_Distributions_all DIST
1079: , PA_Tasks TASK
1080: , HR_Organization_Units ORG
1081: WHERE
1082: DIST.Invoice_Id = InvRec.Invoice_Id
1083: AND DIST.Invoice_Distribution_Id = InvRec.Invoice_Distribution_Id
1084: AND ORG.Organization_Id = NVL(l_exp_org_id,InvRec.Expenditure_Organization_Id) /* Bug 13853188 */

Line 1513: , HR_Organization_Units ORG

1509: , l_system_reference
1510: FROM
1511: AP_Invoice_Distributions_all DIST
1512: , PA_Tasks TASK
1513: , HR_Organization_Units ORG
1514: WHERE
1515: DIST.Invoice_Id = InvRec.Invoice_Id
1516: AND DIST.Invoice_Distribution_Id = InvRec.Invoice_Distribution_Id
1517: AND ORG.Organization_Id = NVL(l_exp_org_id,InvRec.Expenditure_Organization_Id) /* Bug 13853188 */

Line 1952: , HR_Organization_Units ORG

1948: , l_system_reference
1949: FROM
1950: AP_Invoice_Distributions_all DIST
1951: , PA_Tasks TASK
1952: , HR_Organization_Units ORG
1953: WHERE
1954: DIST.Invoice_Id = InvRec.Invoice_Id
1955: AND DIST.Invoice_Distribution_Id = InvRec.Invoice_Distribution_Id
1956: -- AND DIST.PA_Addition_Flag = 'S'

Line 2381: , HR_Organization_Units ORG

2377: , l_system_reference
2378: FROM
2379: AP_Invoice_Distributions_all DIST
2380: , PA_Tasks TASK
2381: , HR_Organization_Units ORG
2382: WHERE
2383: DIST.Invoice_Id = InvRec.Invoice_Id
2384: AND DIST.Invoice_Distribution_Id = InvRec.Invoice_Distribution_Id
2385: -- AND DIST.PA_Addition_Flag = 'S'