APPS.PAY_DK_ARCHIVE_EHOL dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 872: SELECT pay_assignment_actions_s.NEXTVAL

868:
869: --Only Active Hourly(Annual Report)
870: OR (l_report_type = 'PYDKEHOLCA_ANN' and l_hourly_salaried ='H' and l_term_date > l_canonical_end_date)
871: THEN
872: SELECT pay_assignment_actions_s.NEXTVAL
873: INTO l_actid
874: FROM dual;
875:
876: -- Create the archive assignment action

Line 901: SELECT pay_assignment_actions_s.NEXTVAL

897: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id
898: --AND l_prev_person_id <> rec_prepaid_assignments.person_id
899: AND l_prev_assg_id <> rec_prepaid_assignments.assignment_id
900: THEN
901: SELECT pay_assignment_actions_s.NEXTVAL
902: INTO l_actid
903: FROM dual;
904:
905: -- Create the archive assignment action