APPS.CN_QUOTA_PAY_ELEMENTS_PVT dependencies on GL_SETS_OF_BOOKS

Line 23: ,gl_sets_of_books glsob

19:
20: CURSOR get_element IS
21: select f.element_name element_name
22: from pay_element_types_f f
23: ,gl_sets_of_books glsob
24: ,cn_repositories cnr
25: where f.element_type_id = p_element_type_id
26: AND cnr.set_of_books_id = glsob.set_of_books_id
27: AND f.input_currency_code = glsob.currency_code;

Line 290: FROM gl_sets_of_books glsob,

286: x_element_type_id OUT NOCOPY NUMBER ) IS
287:
288: CURSOR get_functional_currency IS
289: SELECT currency_code
290: FROM gl_sets_of_books glsob,
291: cn_repositories cnr
292: WHERE cnr.set_of_books_id = glsob.set_of_books_id;
293:
294: l_functional_currency gl_sets_of_books.currency_code%TYPE;

Line 294: l_functional_currency gl_sets_of_books.currency_code%TYPE;

290: FROM gl_sets_of_books glsob,
291: cn_repositories cnr
292: WHERE cnr.set_of_books_id = glsob.set_of_books_id;
293:
294: l_functional_currency gl_sets_of_books.currency_code%TYPE;
295:
296: BEGIN
297:
298: OPEN get_functional_currency;

Line 1125: gl_sets_of_books glsob,

1121: cpet.effective_end_Date
1122: FROM cn_quota_pay_elements cqpe,
1123: pay_element_types_f cpet,
1124: cn_quota_lookups_v cq,
1125: gl_sets_of_books glsob,
1126: cn_repositories cnr
1127: where
1128: cnr.set_of_books_id = glsob.set_of_books_id
1129: AND cpet.input_currency_code = glsob.currency_code

Line 1150: gl_sets_of_books glsob,

1146: cpet.effective_end_Date
1147: FROM cn_quota_pay_elements cqpe,
1148: pay_element_types_f cpet,
1149: cn_quota_lookups_v cq,
1150: gl_sets_of_books glsob,
1151: cn_repositories cnr
1152: where
1153: cnr.set_of_books_id = glsob.set_of_books_id
1154: AND cpet.input_currency_code = glsob.currency_code