DBA Data[Home] [Help]

APPS.PAY_GB_ENROLL_PENSION dependencies on PER_ALL_POSITIONS

Line 1863: per_all_positions p

1859: CURSOR c_position(p_position VARCHAR2)
1860: IS
1861: SELECT 1
1862: FROM per_all_assignments_f a,
1863: per_all_positions p
1864: WHERE assignment_id =p_assignment_id
1865: AND p.business_group_id = G_BUSINESS_GROUP_ID
1866: AND p.POSITION_ID = a.POSITION_ID
1867: AND p.name =p_position