DBA Data[Home] [Help]

APPS.PER_JP_EMPDET_ARCHIVE_PKG dependencies on PER_ADDRESSES

Line 1530: per_addresses pac,

1526: 'N',to_char(least(nvl(ppos.actual_termination_date,g_effective_date),g_effective_date),'YYYY/MM/DD'),
1527: to_char(nvl(ppos.actual_termination_date,g_effective_date),'YYYY/MM/DD')),'YYYY/MM/DD')
1528: between pp.effective_start_date and pp.effective_end_date) v,
1529: per_jobs_vl pj,
1530: per_addresses pac,
1531: per_phones pphh,
1532: per_phones pphm,
1533: per_phones pphw
1534: where pj.job_id (+) = v.job_id