APPS.PA_INVOICE_XFER dependencies on HR_ORGANIZATION_INFORMATION

Line 1318: | from PA_Implementations, use HR_Organization_Information |

1314: END get_reject_reason;
1315:
1316: /*===============================================================+
1317: | To get the AR Trx Type, instead of using the Invoice_Org_Type |
1318: | from PA_Implementations, use HR_Organization_Information |
1319: | table. There should be a rec for the org in this table |
1320: | satisfying the conditions detailed below. Org-Reorg changes. |
1321: | Also, use Proj_Org_Structure_version_id, Proj_Org_Structure_id|
1322: | and Proj_Start_Org_id |

Line 1379: FROM hr_organization_information orginfo

1375: AND type.name = substrb(org_tl.organization_id ||org_tl.name,1,17) /*Modified for bug 6021078 */
1376: AND SYSDATE BETWEEN type.start_date AND NVL (type.end_date, SYSDATE+1)
1377: AND EXISTS (
1378: SELECT 'x'
1379: FROM hr_organization_information orginfo
1380: WHERE orginfo.organization_id = ip_org_id
1381: AND orginfo.org_information_context = 'CLASS'
1382: AND orginfo.org_information1 = 'PA_INVOICE_ORG'
1383: AND orginfo.org_information2 = 'Y' );