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 1000: , pay_element_types_f types

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

Line 1022: FROM pay_element_types_f types

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

Line 1074: FROM pay_element_types_f

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

Line 1526: FROM pay_element_types_f types

1522: IS
1523: SELECT inputs.name name
1524: , inputs.input_value_id id
1525: , inputs.default_value value
1526: FROM pay_element_types_f types
1527: , pay_input_values_f inputs
1528: WHERE types.element_type_id = p_element_type_id
1529: AND inputs.element_type_id = types.element_type_id
1530: --AND inputs.legislation_code = 'IN'