DBA Data[Home] [Help]

APPS.PER_US_VETC_TAP dependencies on HR_SOFT_CODING_KEYFLEX

Line 260: hr_soft_coding_keyflex scf,

256: FROM per_people_f peo,
257: per_assignments_f ass,
258: hr_organization_information hoi1,
259: hr_organization_information hoi2,
260: hr_soft_coding_keyflex scf,
261: per_jobs job
262: WHERE peo.person_id = ass.person_id
263: AND job.job_information_category = 'US'
264: AND job.date_from <=

Line 351: hr_soft_coding_keyflex scf,

347: FROM per_people_f peo,
348: per_assignments_f ass,
349: hr_organization_information hoi1,
350: hr_organization_information hoi2,
351: hr_soft_coding_keyflex scf,
352: per_jobs job
353: WHERE peo.person_id = ass.person_id
354: AND job.job_information_category = 'US'
355: AND job.date_from <=

Line 436: hr_soft_coding_keyflex scf,

432: hr_establishments_v hev,
433: hr_locations hl,
434: pay_state_rules psr,
435: hr_organization_information hoi1,
436: hr_soft_coding_keyflex scf,
437: per_jobs job
438: WHERE job.job_information_category = 'US'
439: AND job.date_from <=
440: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE_END'),'YYYY/MM/DD HH24:MI:SS')

Line 496: hr_soft_coding_keyflex scf,

492: SELECT 'TRANSFER_MIN_COUNT_ASSIGNMENTS=P',
493: count (distinct pds.person_id)
494: FROM per_periods_of_service pds,
495: per_assignments_f ass,
496: hr_soft_coding_keyflex scf,
497: per_jobs job
498: WHERE pds.date_start <
499: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE_START'),'YYYY/MM/DD HH24:MI:SS')
500: AND (nvl(pds.actual_termination_date,