APPS.CN_QUOTA_PAY_ELEMENTS_PVT dependencies on PAY_ELEMENT_TYPES_F

Line 22: from pay_element_types_f f

18: FUNCTION get_element_type(p_element_type_id NUMBER) RETURN VARCHAR2 IS
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

Line 29: l_name pay_element_types_f.element_name%TYPE;

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;
28:
29: l_name pay_element_types_f.element_name%TYPE;
30:
31: BEGIN
32: open get_element;
33: fetch get_element into l_name;

Line 304: FROM pay_element_types_f

300: CLOSE get_functional_currency;
301:
302: SELECT element_type_id
303: INTO x_element_type_id
304: FROM pay_element_types_f
305: WHERE element_name = p_pay_element_name
306: AND input_currency_code = l_functional_currency
307: AND p_start_date between effective_start_date and effective_end_date
308: AND effective_end_date >= nvl(p_end_date, effective_end_date);

Line 1123: pay_element_types_f cpet,

1119: cpet.element_name,
1120: cpet.effective_start_date,
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

Line 1148: pay_element_types_f cpet,

1144: cpet.element_name,
1145: cpet.effective_start_date,
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