DBA Data[Home] [Help]

APPS.BEN_CWB_WS_IMPORT_PKG dependencies on PER_JOBS

Line 702: from per_jobs_tl jtl , per_jobs j

698: and txn.transaction_type = 'CWBASG'|| trim(l_asg_updt_eff_date);
699:
700: cursor c_job (bg_id In Number) is
701: select j.job_id
702: from per_jobs_tl jtl , per_jobs j
703: where jtl.name = P_PROPOSED_JOB
704: and jtl.language = 'US'
705: and jtl.job_id = j.job_id
706: and j.business_group_id = bg_id