APPS.PAY_IN_INDIA_BENEFITS dependencies on PAY_ELEMENT_TYPES_F

Line 74: , pay_element_types_f types

70: SELECT types.element_type_id
71: ,link.element_link_id
72: FROM per_assignments_f assgn
73: , pay_element_links_f link
74: , pay_element_types_f types
75: WHERE assgn.assignment_id = p_assignment_id
76: AND link.element_link_id = pay_in_utils.get_element_link_id(p_assignment_id
77: ,P_ENTRY_DATE
78: ,types.element_type_id

Line 96: FROM pay_element_types_f types

92: IS
93: SELECT inputs.name name
94: , inputs.input_value_id id
95: , inputs.default_value value
96: FROM pay_element_types_f types
97: , pay_input_values_f inputs
98: WHERE types.element_type_id = p_element_type_id
99: AND inputs.element_type_id = types.element_type_id
100: AND p_effective_date BETWEEN types.effective_start_date AND types.effective_end_date

Line 150: FROM pay_element_types_f

146:
147: CURSOR c_element(p_element_type_id NUMBER)
148: IS
149: SELECT element_name
150: FROM pay_element_types_f
151: WHERE element_type_id = p_element_type_id ;
152:
153: CURSOR c_ltc_carry_over(p_element_entry_id NUMBER)
154: IS SELECT nvl(peev.screen_entry_value,'N')

Line 1154: pay_element_types_f pet,

1150: IS
1151: SELECT screen_entry_value
1152: FROM pay_element_entry_values_f peev,
1153: pay_element_entries_f pev,
1154: pay_element_types_f pet,
1155: pay_input_values_f piv
1156: WHERE pev.assignment_id = p_assignment_id
1157: AND pev.element_type_id = pet.element_type_id
1158: AND pev.element_entry_id = peev.element_entry_id

Line 1870: FROM pay_element_types_f types

1866: IS
1867: SELECT inputs.name name
1868: , inputs.input_value_id id
1869: , inputs.default_value value
1870: FROM pay_element_types_f types
1871: , pay_input_values_f inputs
1872: WHERE types.element_type_id = p_element_type_id
1873: AND inputs.element_type_id = types.element_type_id
1874: --AND inputs.legislation_code = 'IN'