DBA Data[Home] [Help]

APPS.PAY_PYUCSLIS_PKG dependencies on HR_ALL_POSITIONS_F

Line 631: FROM hr_all_positions_f pp,

627: l_update_date
628: FROM per_pos_structure_elements p
629: WHERE EXISTS
630: (SELECT NULL
631: FROM hr_all_positions_f pp,
632: per_organization_list ol
633: WHERE ol.organization_id = pp.organization_id
634: AND pp.position_id = p.subordinate_position_id
635: AND ol.security_profile_id= l_security_profile_id)

Line 669: FROM hr_all_positions_f pp,

665: l_update_date
666: FROM sys.dual
667: WHERE EXISTS
668: (SELECT NULL
669: FROM hr_all_positions_f pp,
670: per_organization_list ol
671: WHERE ol.organization_id = pp.organization_id
672: AND pp.position_id = l_position_id
673: AND ol.security_profile_id= l_security_profile_id);