APPS.PAY_SEED_UTL dependencies on PAY_ELEMENT_TYPES_F

Line 24: from pay_element_types_f

20: -- Cursor to retrieve element_type_id given name - as name doesnt change date effectivly
21: CURSOR c_element_name_id(p_element_name VARCHAR2,
22: p_legislation_code VARCHAR2) IS
23: select element_type_id
24: from pay_element_types_f
25: where element_name = p_element_name
26: and legislation_code = p_legislation_code
27: and business_group_id IS NULL;
28:

Line 34: from pay_element_types_f e, pay_input_values_f i

30: CURSOR c_input_name_id(p_element_name VARCHAR2,
31: p_input_value_name VARCHAR2,
32: p_legislation_code VARCHAR2) IS
33: select i.input_value_id
34: from pay_element_types_f e, pay_input_values_f i
35: where e.element_name = p_element_name
36: and i.name = p_input_value_name
37: and i.element_type_id = e.element_type_id
38: and i.legislation_code = p_legislation_code

Line 221: from pay_element_types_f

217: -- Cursor to retrieve element_type_id given name - as name doesnt change date effectivly
218: CURSOR c_element_name_id(p_element_name VARCHAR2,
219: p_legislation_code VARCHAR2) IS
220: select element_type_id
221: from pay_element_types_f
222: where element_name = p_element_name
223: and legislation_code = p_legislation_code
224: and business_group_id IS NULL;
225:

Line 250: from pay_element_types_f e, pay_input_values_f i

246: CURSOR c_input_name_id(p_element_name VARCHAR2,
247: p_input_value_name VARCHAR2,
248: p_legislation_code VARCHAR2) IS
249: select i.input_value_id
250: from pay_element_types_f e, pay_input_values_f i
251: where e.element_name = p_element_name
252: and i.name = p_input_value_name
253: and i.element_type_id = e.element_type_id
254: and i.legislation_code = p_legislation_code

Line 518: FROM pay_element_types_f

514: return VARCHAR2
515: IS
516: CURSOR csr_element_name(p_element_type_id NUMBER) IS
517: SELECT distinct element_name
518: FROM pay_element_types_f
519: WHERE element_type_id = p_element_type_id;
520:
521: CURSOR csr_element_id(p_element_name VARCHAR2,
522: p_legislation_code VARCHAR2) IS

Line 524: FROM pay_element_types_f

520:
521: CURSOR csr_element_id(p_element_name VARCHAR2,
522: p_legislation_code VARCHAR2) IS
523: SELECT element_type_id
524: FROM pay_element_types_f
525: WHERE element_type_id = p_column_value
526: AND legislation_code = p_legislation_code;
527:
528: CURSOR csr_balance_name(p_balance_type_id NUMBER) IS

Line 662: FROM pay_element_types_f

658: return VARCHAR2
659: IS
660: CURSOR csr_element_name(p_element_type_id NUMBER) IS
661: SELECT distinct element_name
662: FROM pay_element_types_f
663: WHERE element_type_id = p_element_type_id;
664:
665: CURSOR csr_element_id(p_element_name VARCHAR2,
666: p_legislation_code VARCHAR2) IS

Line 668: FROM pay_element_types_f

664:
665: CURSOR csr_element_id(p_element_name VARCHAR2,
666: p_legislation_code VARCHAR2) IS
667: SELECT element_type_id
668: FROM pay_element_types_f
669: WHERE element_type_id = p_column_value
670: AND legislation_code = p_legislation_code;
671:
672: CURSOR csr_balance_name(p_balance_type_id NUMBER) IS