APPS.PAY_IN_MED_WEB_ADI dependencies on PAY_ELEMENT_TYPES

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 192: l_element pay_element_types.element_name%TYPE ;

188: l_ben_input_values_rec t_input_values_tab;
189: l_business_group_id NUMBER;
190: l_medical_bill_element hr_organization_information.org_information2%TYPE ;
191: l_medical_ben_element hr_organization_information.org_information2%TYPE ;
192: l_element pay_element_types.element_name%TYPE ;
193: l_count NUMBER;
194: l_assignment_id NUMBER;
195: l_bill_element_type_id NUMBER;
196: l_bill_element_link_id NUMBER;

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 1094: l_element pay_element_types.element_name%TYPE ;

1090: l_ben_input_values_rec t_input_values_tab;
1091: l_business_group_id NUMBER;
1092: l_medical_bill_element hr_organization_information.org_information2%TYPE ;
1093: l_ltc_element hr_organization_information.org_information2%TYPE ;
1094: l_element pay_element_types.element_name%TYPE ;
1095: l_count NUMBER;
1096: l_assignment_id NUMBER;
1097: l_ltc_element_type_id NUMBER;
1098: l_bill_element_link_id NUMBER;

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'