APPS.HR_LEGISLATION dependencies on PAY_REPORT_FORMAT_ITEMS_S

Line 6213: select pay_report_format_items_s.nextval

6209: select max(report_format_item_id)
6210: into v_max_live
6211: from pay_report_format_items_f;
6212:
6213: select pay_report_format_items_s.nextval
6214: into v_sequence_number
6215: from dual;
6216:
6217: IF (v_sequence_number BETWEEN v_min_delivered AND v_max_delivered)

Line 6222: hr_legislation.munge_sequence('PAY_REPORT_FORMAT_ITEMS_S',

6218: OR (v_sequence_number < v_max_live) THEN
6219:
6220: IF v_max_live > v_max_delivered THEN
6221:
6222: hr_legislation.munge_sequence('PAY_REPORT_FORMAT_ITEMS_S',
6223: v_sequence_number,
6224: v_max_live);
6225: ELSE
6226:

Line 6227: hr_legislation.munge_sequence('PAY_REPORT_FORMAT_ITEMS_S',

6223: v_sequence_number,
6224: v_max_live);
6225: ELSE
6226:
6227: hr_legislation.munge_sequence('PAY_REPORT_FORMAT_ITEMS_S',
6228: v_sequence_number,
6229: v_max_delivered);
6230: END IF;
6231: END IF;

Line 6256: select pay_report_format_items_s.nextval

6252:
6253:
6254: EXCEPTION WHEN NO_DATA_FOUND THEN
6255:
6256: select pay_report_format_items_s.nextval
6257: into l_new_surrogate_key
6258: from dual;
6259:
6260: WHEN TOO_MANY_ROWS THEN

Line 6277: select pay_report_format_items_s.nextval

6273: END;
6274:
6275: if l_new_surrogate_key is null then
6276:
6277: select pay_report_format_items_s.nextval
6278: into l_new_surrogate_key
6279: from dual;
6280:
6281: end if;