DBA Data[Home] [Help]

APPS.HR_LEGISLATION_LOCAL dependencies on PAY_US_GARN_EXEMPTION_RULES_S

Line 1015: PAY_US_GARN_EXEMPTION_RULES_S.nextval, -- changes for nextval */

1011: therefore safe to use the ids from the hr_s table. This will help in
1012: maintainig the correct ids for date-tracked rows. After inserting
1013: all the rows we will set the sequence to start at a value higher than the
1014: max value of the id in pay_us_garn_exemption_rules_f.
1015: PAY_US_GARN_EXEMPTION_RULES_S.nextval, -- changes for nextval */
1016: ger_rec.EFFECTIVE_START_DATE,
1017: ger_rec.EFFECTIVE_END_DATE,
1018: ger_rec.GARN_CATEGORY,
1019: ger_rec.STATE_CODE,

Line 1046: select PAY_US_GARN_EXEMPTION_RULES_S.nextval

1042:
1043: /* consume sequence till there is no conflict */
1044: while l_next_val < l_max_val
1045: loop
1046: select PAY_US_GARN_EXEMPTION_RULES_S.nextval
1047: into l_next_val
1048: from dual;
1049: end loop;
1050: