APPS.PAY_US_BALANCE_FEEDS_HOOK dependencies on PAY_ELEMENT_TYPES_F

Line 27: 1. Puts time_definition_type as 'G' in pay_element_types_f

23: Description : This package is called from the AFTER INSERT/UPDATE
24: User Hooks. The following are the functionalities present
25: in User Hook
26:
27: 1. Puts time_definition_type as 'G' in pay_element_types_f
28: whenever that element feeds a balance for which defined
29: balance exists with dimensions:
30: _ASG_GRE_TD_RUN
31: _ASG_GRE_TD_BD_RUN

Line 126: UPDATE pay_element_types_f

122: IF ((get_element_type_id%NOTFOUND) OR (ln_element_type_id IS NULL)) THEN
123: hr_utility.trace('No required element_type_id exists');
124: ELSE
125: /*Update the time_definition_type to G for the element found above*/
126: UPDATE pay_element_types_f
127: SET time_definition_type = 'G'
128: WHERE element_type_id = ln_element_type_id
129: AND ((business_group_id IS NULL AND legislation_code = 'US') OR -- For Seeded
130: (business_group_id = p_business_group_id AND legislation_code IS NULL) -- For Custom

Line 163: -- The local procedure inserts time_definition_type as 'G' in pay_element_types_f

159:
160: hr_utility.trace('Entering PAY_US_BALANCE_FEEDS_HOOK.INSERT_USER_HOOK');
161:
162: -- Call INSERT_TIMEDEF_TYPE
163: -- The local procedure inserts time_definition_type as 'G' in pay_element_types_f
164: -- whenever that element feeds a balance for which defined balance exists with dimensions:
165: -- _ASG_GRE_TD_RUN and _ASG_GRE_TD_BD_RUN. These checks are handled as a part of the
166: -- local procedure
167: INSERT_TIMEDEF_TYPE(