DBA Data[Home] [Help]

APPS.PAY_DK_PR_ASG dependencies on DUAL

Line 578: SELECT pay_assignment_actions_s.NEXTVAL INTO l_actid FROM dual;

574: IF (csr_rec.pay_value > 0) THEN -- to archive only elements which have pay value > 0
575: --check for change of assignment id to create new assignment action id
576: IF (csr_rec.asg_act_id <> l_asg_act_id) THEN
577: BEGIN
578: SELECT pay_assignment_actions_s.NEXTVAL INTO l_actid FROM dual;
579: EXCEPTION
580: WHEN OTHERS THEN
581: NULL ;
582: END ;

Line 633: SELECT pay_assignment_actions_s.NEXTVAL INTO l_actid FROM dual;

629: IF (csr_rec.pay_value > 0) THEN -- to archive only elements which have pay value > 0
630: --check for change of assignment id to create new assignment action id
631: IF (csr_rec.asg_act_id <> l_asg_act_id) THEN
632: BEGIN
633: SELECT pay_assignment_actions_s.NEXTVAL INTO l_actid FROM dual;
634: EXCEPTION
635: WHEN OTHERS THEN
636: NULL ;
637: END ;