DBA Data[Home] [Help]

APPS.PAY_RETRO_PKG dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 1159: select pay_assignment_actions_s.nextval,

1155: source_action_id,
1156: object_id,
1157: object_type
1158: )
1159: select pay_assignment_actions_s.nextval,
1160: asgrec.source_id,
1161: p_pactid,
1162: 'U',
1163: p_chunk_number,

Line 1164: pay_assignment_actions_s.nextval,

1160: asgrec.source_id,
1161: p_pactid,
1162: 'U',
1163: p_chunk_number,
1164: pay_assignment_actions_s.nextval,
1165: 1,
1166: asgrec.tax_unit_id,
1167: actrec.assignment_action_id,
1168: actrec.process_group_id,

Line 1181: set action_sequence = pay_assignment_actions_s.nextval

1177: end loop;
1178: --
1179: -- Now update the master Sequence
1180: update pay_assignment_actions
1181: set action_sequence = pay_assignment_actions_s.nextval
1182: where assignment_action_id = actrec.assignment_action_id;
1183: --
1184: end loop;
1185: --