APPS.PAY_IN_INDIA_BENEFITS dependencies on PAY_ELEMENT_TYPES_F

Line 70: , pay_element_types_f types

66: SELECT types.element_type_id
67: ,link.element_link_id
68: FROM per_assignments_f assgn
69: , pay_element_links_f link
70: , pay_element_types_f types
71: WHERE assgn.assignment_id = p_assignment_id
72: AND link.element_link_id = pay_in_utils.get_element_link_id(p_assignment_id
73: ,P_ENTRY_DATE
74: ,types.element_type_id

Line 92: FROM pay_element_types_f types

88: IS
89: SELECT inputs.name name
90: , inputs.input_value_id id
91: , inputs.default_value value
92: FROM pay_element_types_f types
93: , pay_input_values_f inputs
94: WHERE types.element_type_id = p_element_type_id
95: AND inputs.element_type_id = types.element_type_id
96: AND p_effective_date BETWEEN types.effective_start_date AND types.effective_end_date

Line 144: FROM pay_element_types_f

140:
141: CURSOR c_element(p_element_type_id NUMBER)
142: IS
143: SELECT element_name
144: FROM pay_element_types_f
145: WHERE element_type_id = p_element_type_id ;
146:
147: CURSOR c_ltc_carry_over(p_element_entry_id NUMBER)
148: IS SELECT nvl(peev.screen_entry_value,'N')

Line 1105: pay_element_types_f pet,

1101: IS
1102: SELECT screen_entry_value
1103: FROM pay_element_entry_values_f peev,
1104: pay_element_entries_f pev,
1105: pay_element_types_f pet,
1106: pay_input_values_f piv
1107: WHERE pev.assignment_id = p_assignment_id
1108: AND pev.element_type_id = pet.element_type_id
1109: AND pev.element_entry_id = peev.element_entry_id

Line 1797: FROM pay_element_types_f types

1793: IS
1794: SELECT inputs.name name
1795: , inputs.input_value_id id
1796: , inputs.default_value value
1797: FROM pay_element_types_f types
1798: , pay_input_values_f inputs
1799: WHERE types.element_type_id = p_element_type_id
1800: AND inputs.element_type_id = types.element_type_id
1801: --AND inputs.legislation_code = 'IN'