DBA Data[Home] [Help]

APPS.PAY_DB_LOCALISATION_PKG dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 232: insert into pay_element_classifications

228: l_parent_id number,
229: l_costable_flag varchar2) return number is
230: new_id number;
231: begin
232: insert into pay_element_classifications
233: (classification_id,
234: business_group_id,
235: legislation_code,
236: classification_name,

Line 248: (pay_element_classifications_s.nextval,

244: non_payments_flag,
245: parent_classification_id,
246: costable_flag)
247: values
248: (pay_element_classifications_s.nextval,
249: NULL,
250: 'BF',
251: l_classification_name,
252: l_description,

Line 263: select pay_element_classifications_s.currval

259: l_non_payments_flag,
260: l_parent_id,
261: l_costable_flag);
262: --
263: select pay_element_classifications_s.currval
264: into new_id
265: from dual;
266: --
267: return new_id;

Line 492: insert into pay_element_classifications

488: l_non_payments_flag varchar2,
489: l_parent_id number) return number is
490: new_id number;
491: begin
492: insert into pay_element_classifications
493: (classification_id,
494: business_group_id,
495: legislation_code,
496: classification_name,

Line 507: (pay_element_classifications_s.nextval,

503: distributable_over_flag,
504: non_payments_flag,
505: parent_classification_id)
506: values
507: (pay_element_classifications_s.nextval,
508: NULL,
509: 'GB',
510: l_classification_name,
511: l_description,

Line 521: select pay_element_classifications_s.currval

517: l_distributable_over_flag,
518: l_non_payments_flag,
519: l_parent_id);
520: --
521: select pay_element_classifications_s.currval
522: into new_id
523: from dual;
524: --
525: return new_id;