APPS.PAY_IN_MED_WEB_ADI dependencies on PAY_ELEMENT_TYPES_F

Line 98: , pay_element_types_f types

94: SELECT types.element_type_id
95: ,link.element_link_id
96: FROM per_assignments_f assgn
97: , pay_element_links_f link
98: , pay_element_types_f types
99: WHERE assgn.assignment_id = p_assignment_id
100: AND link.element_link_id = pay_in_utils.get_element_link_id(p_assignment_id
101: ,P_ENTRY_DATE
102: ,types.element_type_id

Line 120: FROM pay_element_types_f types

116: IS
117: SELECT inputs.name name
118: , inputs.input_value_id id
119: , inputs.default_value value
120: FROM pay_element_types_f types
121: , pay_input_values_f inputs
122: WHERE types.element_type_id = p_element_type_id
123: AND inputs.element_type_id = types.element_type_id
124: AND p_effective_date BETWEEN types.effective_start_date AND types.effective_end_date

Line 171: FROM pay_element_types_f

167:
168: CURSOR c_element(p_element_type_id NUMBER)
169: IS
170: SELECT element_name
171: FROM pay_element_types_f
172: WHERE element_type_id = p_element_type_id ;
173:
174:
175: --Variables Initialization

Line 791: FROM pay_element_types_f types

787: IS
788: SELECT inputs.name name
789: , inputs.input_value_id id
790: , inputs.default_value value
791: FROM pay_element_types_f types
792: , pay_input_values_f inputs
793: WHERE types.element_type_id = p_element_type_id
794: AND inputs.element_type_id = types.element_type_id
795: AND p_effective_date BETWEEN types.effective_start_date AND types.effective_end_date

Line 999: , pay_element_types_f types

995: SELECT types.element_type_id
996: ,link.element_link_id
997: FROM per_assignments_f assgn
998: , pay_element_links_f link
999: , pay_element_types_f types
1000: WHERE assgn.assignment_id = p_assignment_id
1001: AND link.element_link_id = pay_in_utils.get_element_link_id(p_assignment_id
1002: ,P_ENTRY_DATE
1003: ,types.element_type_id

Line 1021: FROM pay_element_types_f types

1017: IS
1018: SELECT inputs.name name
1019: , inputs.input_value_id id
1020: , inputs.default_value value
1021: FROM pay_element_types_f types
1022: , pay_input_values_f inputs
1023: WHERE types.element_type_id = p_element_type_id
1024: AND inputs.element_type_id = types.element_type_id
1025: AND p_effective_date BETWEEN types.effective_start_date AND types.effective_end_date

Line 1073: FROM pay_element_types_f

1069:
1070: CURSOR c_element(p_element_type_id NUMBER)
1071: IS
1072: SELECT element_name
1073: FROM pay_element_types_f
1074: WHERE element_type_id = p_element_type_id ;
1075:
1076: --Variables Initialization
1077: TYPE t_input_values_rec IS RECORD

Line 1514: FROM pay_element_types_f types

1510: IS
1511: SELECT inputs.name name
1512: , inputs.input_value_id id
1513: , inputs.default_value value
1514: FROM pay_element_types_f types
1515: , pay_input_values_f inputs
1516: WHERE types.element_type_id = p_element_type_id
1517: AND inputs.element_type_id = types.element_type_id
1518: --AND inputs.legislation_code = 'IN'