DBA Data[Home] [Help]

APPS.PAY_GB_ENROLL_PENSION dependencies on PER_JOBS

Line 1843: per_jobs j

1839: CURSOR c_job(p_job VARCHAR2)
1840: IS
1841: SELECT 1
1842: FROM per_all_assignments_f a,
1843: per_jobs j
1844: WHERE assignment_id =p_assignment_id
1845: AND j.business_group_id = G_BUSINESS_GROUP_ID
1846: AND j.JOB_ID = a.JOB_ID
1847: AND j.name =p_job