APPS.PAY_LOAD_PARAMETERS dependencies on PAY_PARAMETERS

Line 111: -- Procedure used to upload seed data for the table PAY_PARAMETERS

107: -- |-----------------------< load_parameters >----------------------|
108: -- ----------------------------------------------------------------------------
109: --
110: -- Description:
111: -- Procedure used to upload seed data for the table PAY_PARAMETERS
112: --
113: -- ----------------------------------------------------------------------------
114: procedure load_parameters
115: ( p_parameter_name in varchar2

Line 125: from pay_parameters pp,

121: ) AS
122:
123: cursor pp_exits(p_parameter_name varchar2) is
124: select pp.parameter_id
125: from pay_parameters pp,
126: pay_parameter_definitions ppd,
127: per_business_groups pbg
128: where ppd.parameter_name = p_parameter_name
129: AND ppd.parameter_def_id = pp.parameter_def_id

Line 163: UPDATE PAY_PARAMETERS SET

159: end if;
160: --
161: if(found = TRUE) then
162:
163: UPDATE PAY_PARAMETERS SET
164: qualifier = p_qualifier
165: , override_allowed = p_override_allowed
166: ,LAST_UPDATED_BY = decode(p_owner,'SEED',1,0)
167: ,LAST_UPDATE_DATE = SYSDATE

Line 179: INSERT INTO PAY_PARAMETERS (

175: close get_param_def_id;
176:
177: hr_utility.trace('Before inserting, l_param_def_id : '||l_parameter_def_id);
178:
179: INSERT INTO PAY_PARAMETERS (
180: parameter_id
181: , parameter_def_id
182: , qualifier
183: , override_allowed

Line 192: PAY_PARAMETERS_S.nextval

188: ,LAST_UPDATE_LOGIN
189: ,CREATION_DATE
190: ,CREATED_BY )
191: VALUES (
192: PAY_PARAMETERS_S.nextval
193: , l_parameter_def_id
194: , p_qualifier
195: , p_override_allowed
196: , l_business_group_id