APPS.JAI_PO_HOOK_PKG dependencies on HR_OPERATING_UNITS

Line 96: FROM hr_operating_units

92: AND NVL(A.Org_Id, 0) = p_org_id;
93:
94: CURSOR c_sob(cp_org_id IN NUMBER) IS
95: SELECT set_of_books_id
96: FROM hr_operating_units
97: WHERE organization_id = cp_org_id;
98:
99: CURSOR c_hdr_info IS
100: SELECT *

Line 1252: FROM hr_operating_units

1248: SELECT currency_code
1249: FROM gl_sets_of_booKs
1250: WHERE set_of_books_id IN
1251: (SELECT set_of_books_id
1252: FROM hr_operating_units
1253: WHERE organization_id = cp_org_id);
1254:
1255: -- pramasub start
1256: CURSOR c_cmn_doc_taxes(cp_cmn_line_id IN NUMBER, cp_doc_type IN VARCHAR2) IS

Line 1592: FROM hr_operating_units

1588: SELECT currency_code
1589: FROM gl_sets_of_booKs
1590: WHERE set_of_books_id IN
1591: (SELECT set_of_books_id
1592: FROM hr_operating_units
1593: WHERE organization_id = cp_org_id);
1594:
1595: ln_tax_amt NUMBER ;
1596: ln_conv_rate NUMBER ;

Line 1833: FROM hr_operating_units

1829: SELECT currency_code
1830: FROM gl_sets_of_booKs
1831: WHERE set_of_books_id IN
1832: (SELECT set_of_books_id
1833: FROM hr_operating_units
1834: WHERE organization_id = cp_org_id);
1835:
1836: -- pramasub start /*for asn/asbn*/
1837: CURSOR c_cmn_doc_taxes(cp_cmn_line_id IN NUMBER, cp_doc_type IN VARCHAR2) IS

Line 2297: FROM hr_operating_units

2293: SELECT currency_code
2294: FROM gl_sets_of_booKs
2295: WHERE set_of_books_id IN
2296: (SELECT set_of_books_id
2297: FROM hr_operating_units
2298: WHERE organization_id = pn_org_id);
2299:
2300: --Get the requisition tax amount for each requisition line currency code
2301: CURSOR reqn_tax_amt_csr IS