DBA Data[Home] [Help]

APPS.PAY_PYUCSLIS_PKG dependencies on HR_ALL_POSITIONS_F

Line 695: FROM hr_all_positions_f pp,

691: l_update_date
692: FROM per_pos_structure_elements p
693: WHERE EXISTS
694: (SELECT NULL
695: FROM hr_all_positions_f pp,
696: per_organization_list ol
697: WHERE ol.organization_id = pp.organization_id
698: AND pp.position_id = p.subordinate_position_id
699: AND ol.security_profile_id= l_security_profile_id)

Line 733: FROM hr_all_positions_f pp,

729: l_update_date
730: FROM sys.dual
731: WHERE EXISTS
732: (SELECT NULL
733: FROM hr_all_positions_f pp,
734: per_organization_list ol
735: WHERE ol.organization_id = pp.organization_id
736: AND pp.position_id = l_position_id
737: AND ol.security_profile_id= l_security_profile_id);