APPS.HR_LEGISLATION_LOCAL dependencies on PAY_US_GARN_FEE_RULES_S

Line 1074: select PAY_US_GARN_FEE_RULES_S.currval

1070: If the ids are the same we will use currval from the sequence as
1071: the new fee rule id else we will use nextval. */
1072: if l_prev_seq = gfr_rec.fee_rule_id
1073: then
1074: select PAY_US_GARN_FEE_RULES_S.currval
1075: into l_next_val
1076: from dual;
1077: else
1078: select PAY_US_GARN_FEE_RULES_S.nextval

Line 1078: select PAY_US_GARN_FEE_RULES_S.nextval

1074: select PAY_US_GARN_FEE_RULES_S.currval
1075: into l_next_val
1076: from dual;
1077: else
1078: select PAY_US_GARN_FEE_RULES_S.nextval
1079: into l_next_val
1080: from dual;
1081: end if;
1082:

Line 1110: pay_us_garn_fee_rules_s.nextval,*/

1106: (
1107: /* use the l_next_val generated
1108: in the previous step to populte the
1109: fee_rule_id
1110: pay_us_garn_fee_rules_s.nextval,*/
1111: l_next_val,
1112: to_date('01/01/0001', 'DD/MM/YYYY'),
1113: to_date('31/12/4712', 'DD/MM/YYYY'),
1114: gfr_rec.GARN_CATEGORY,

Line 1142: select PAY_US_GARN_FEE_RULES_S.nextval

1138:
1139: /* consume sequence till there is no conflict */
1140: while l_next_val < l_max_val
1141: loop
1142: select PAY_US_GARN_FEE_RULES_S.nextval
1143: into l_next_val
1144: from dual;
1145: end loop;
1146: