DBA Data[Home] [Help]

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 1383: FROM hr_organization_information orginfo

1379: AND type.attribute1=to_char(org.organization_id)/*Added for Bug 12607920 as FP*/
1380: AND NVL(p_trans_date,SYSDATE) BETWEEN type.start_date AND NVL (type.end_date, NVL(p_trans_date,SYSDATE)) /* Modified for bug 8687883*/
1381: AND EXISTS (
1382: SELECT 'x'
1383: FROM hr_organization_information orginfo
1384: WHERE orginfo.organization_id = ip_org_id
1385: AND orginfo.org_information_context = 'CLASS'
1386: AND orginfo.org_information1 = 'PA_INVOICE_ORG'
1387: AND orginfo.org_information2 = 'Y' );