[Home] [Help]
45: +---------------------------------------------------------------*/
46:
47: CURSOR all_ous(c_le_id NUMBER) is
48: SELECT distinct hoi.organization_id
49: FROM hr_organization_information hoi
50: WHERE hoi.org_information2 = to_char(c_le_id)
51: AND hoi.org_information_context = 'Operating Unit Information';
52:
53: BEGIN
646: ra_cust_trx_line_gl_dist_all rctlgd,
647: ra_customer_trx_lines_all rctl,
648: oe_order_headers_all rma,
649: oe_order_lines_all rma_line,
650: --hr_organization_information hoi,
651: ra_customer_trx_all rct,
652: mtl_parameters mp -- INVCONV umoogala 17-oct-2004
653: WHERE
654: cr.build_id = l_build_id
1006: ra_cust_trx_line_gl_dist_all rctlgd,
1007: ra_customer_trx_lines_all rctl,
1008: oe_order_headers_all rma,
1009: oe_order_lines_all rma_line,
1010: --hr_organization_information hoi,
1011: ra_customer_trx_all rct,
1012: mtl_parameters mp -- INVCONV umoogala 17-oct-2004
1013: WHERE
1014: cr.build_id = l_build_id
1865: (select gp.period_name, gp.PERIOD_YEAR
1866: from
1867: gl_periods gp,
1868: gl_sets_of_books gsob,
1869: hr_organization_information hoi
1870: where
1871: hoi.org_information1 = gsob.SET_OF_BOOKS_ID
1872: and hoi.org_information_context = 'Legal Entity Accounting'
1873: and gsob.period_set_name = gp.period_set_name
1891: gp.PERIOD_YEAR * 10 + gp.period_num
1892: from
1893: gl_periods gp,
1894: gl_sets_of_books gsob,
1895: hr_organization_information hoi
1896: where
1897: hoi.org_information1 = gsob.SET_OF_BOOKS_ID
1898: and hoi.org_information_context = 'Legal Entity Accounting'
1899: and gsob.period_set_name = gp.period_set_name
1916: gp.PERIOD_YEAR * 100 + gp.period_num
1917: from
1918: gl_periods gp,
1919: gl_sets_of_books gsob,
1920: hr_organization_information hoi
1921: where
1922: hoi.org_information1 = gsob.SET_OF_BOOKS_ID
1923: and hoi.org_information_context = 'Legal Entity Accounting'
1924: and gsob.period_set_name = gp.period_set_name