DBA Data[Home] [Help]

APPS.PAY_RETRO_NOTIF_PKG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 656: FROM hr_assignment_set_amendments

652: , p_asg_set_id IN NUMBER) is
653: --
654: Cursor c_already_in_set is
655: SELECT 'X'
656: FROM hr_assignment_set_amendments
657: WHERE assignment_id = p_assignment_id
658: AND assignment_set_id = p_asg_set_id
659: AND include_or_exclude = 'I';
660: --

Line 1647: FROM hr_assignment_set_amendments

1643: procedure check_retro_asg_set(p_asg_set_id IN NUMBER) is
1644: --
1645: cursor c_check_retro_set is
1646: SELECT 'X'
1647: FROM hr_assignment_set_amendments
1648: WHERE assignment_set_id = p_asg_set_id;
1649: --
1650: l_dummy VARCHAR2(1);
1651: --