APPS.HR_LEGISLATION dependencies on PAY_REPORT_FORMAT_ITEMS_S

Line 6463: select pay_report_format_items_s.nextval

6459: select max(report_format_item_id)
6460: into v_max_live
6461: from pay_report_format_items_f;
6462:
6463: select pay_report_format_items_s.nextval
6464: into v_sequence_number
6465: from dual;
6466:
6467: IF (v_sequence_number BETWEEN v_min_delivered AND v_max_delivered)

Line 6472: hr_legislation.munge_sequence('PAY_REPORT_FORMAT_ITEMS_S',

6468: OR (v_sequence_number < v_max_live) THEN
6469:
6470: IF v_max_live > v_max_delivered THEN
6471:
6472: hr_legislation.munge_sequence('PAY_REPORT_FORMAT_ITEMS_S',
6473: v_sequence_number,
6474: v_max_live);
6475: ELSE
6476:

Line 6477: hr_legislation.munge_sequence('PAY_REPORT_FORMAT_ITEMS_S',

6473: v_sequence_number,
6474: v_max_live);
6475: ELSE
6476:
6477: hr_legislation.munge_sequence('PAY_REPORT_FORMAT_ITEMS_S',
6478: v_sequence_number,
6479: v_max_delivered);
6480: END IF;
6481: END IF;

Line 6506: select pay_report_format_items_s.nextval

6502:
6503:
6504: EXCEPTION WHEN NO_DATA_FOUND THEN
6505:
6506: select pay_report_format_items_s.nextval
6507: into l_new_surrogate_key
6508: from dual;
6509:
6510: WHEN TOO_MANY_ROWS THEN

Line 6527: select pay_report_format_items_s.nextval

6523: END;
6524:
6525: if l_new_surrogate_key is null then
6526:
6527: select pay_report_format_items_s.nextval
6528: into l_new_surrogate_key
6529: from dual;
6530:
6531: end if;