APPS.JAI_PO_HOOK_PKG dependencies on HR_OPERATING_UNITS

Line 56: FROM hr_operating_units

52: AND NVL(A.Org_Id, 0) = p_org_id;
53:
54: CURSOR c_sob(cp_org_id IN NUMBER) IS
55: SELECT set_of_books_id
56: FROM hr_operating_units
57: WHERE organization_id = cp_org_id;
58:
59: CURSOR c_hdr_info IS
60: SELECT *

Line 1123: FROM hr_operating_units

1119: SELECT currency_code
1120: FROM gl_sets_of_booKs
1121: WHERE set_of_books_id IN
1122: (SELECT set_of_books_id
1123: FROM hr_operating_units
1124: WHERE organization_id = cp_org_id);
1125:
1126: -- pramasub start
1127: CURSOR c_cmn_doc_taxes(cp_cmn_line_id IN NUMBER, cp_doc_type IN VARCHAR2) IS

Line 1463: FROM hr_operating_units

1459: SELECT currency_code
1460: FROM gl_sets_of_booKs
1461: WHERE set_of_books_id IN
1462: (SELECT set_of_books_id
1463: FROM hr_operating_units
1464: WHERE organization_id = cp_org_id);
1465:
1466: ln_tax_amt NUMBER ;
1467: ln_conv_rate NUMBER ;

Line 1696: FROM hr_operating_units

1692: SELECT currency_code
1693: FROM gl_sets_of_booKs
1694: WHERE set_of_books_id IN
1695: (SELECT set_of_books_id
1696: FROM hr_operating_units
1697: WHERE organization_id = cp_org_id);
1698:
1699: -- pramasub start /*for asn/asbn*/
1700: CURSOR c_cmn_doc_taxes(cp_cmn_line_id IN NUMBER, cp_doc_type IN VARCHAR2) IS

Line 2109: FROM hr_operating_units

2105: SELECT currency_code
2106: FROM gl_sets_of_booKs
2107: WHERE set_of_books_id IN
2108: (SELECT set_of_books_id
2109: FROM hr_operating_units
2110: WHERE organization_id = pn_org_id);
2111:
2112: --Get the requisition tax amount for each requisition line currency code
2113: CURSOR reqn_tax_amt_csr IS