DBA Data[Home] [Help]

APPS.HR_LEGISLATION_LOCAL dependencies on PAY_US_GARN_LIMIT_RULES_S

Line 1180: PAY_US_GARN_LIMIT_RULES_S.nextval, -- cahnges for nextval */

1176: therefore safe to use the ids from the hr_s table. This will help in
1177: maintainig the correct ids for date-tracked rows. After inserting
1178: all the rows we will set the sequence to start at a value higher than the
1179: max value of the id in pay_us_garn_limit_rules_f.
1180: PAY_US_GARN_LIMIT_RULES_S.nextval, -- cahnges for nextval */
1181: glr_rec.EFFECTIVE_START_DATE,
1182: glr_rec.EFFECTIVE_END_DATE,
1183: glr_rec.GARN_CATEGORY,
1184: glr_rec.STATE_CODE,

Line 1206: select PAY_US_GARN_LIMIT_RULES_S.nextval

1202:
1203: /* consume sequence till there is no conflict */
1204: while l_next_val < l_max_val
1205: loop
1206: select PAY_US_GARN_LIMIT_RULES_S.nextval
1207: into l_next_val
1208: from dual;
1209: end loop;
1210: