APPS.PER_US_VETC_TAP dependencies on PER_ASSIGNMENTS_F

Line 257: per_assignments_f ass,

253: count(decode(peo.per_information5,'VIETVET',1,'VIETVETDIS',1,'DVOEV',1,'VOEVV',1,null)) no_viet_vets,
254: 'TRANSFER_NO_OT_EV=P',
255: nvl(count(decode(peo.per_information5,'OTEV',1,'OTEDV',1,'DVOEV',1,'VOEVV',1,null)),0)
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

Line 348: per_assignments_f ass,

344: count(decode(peo.per_information5,'VIETVET',1,'VIETVETDIS',1,'DVOEV',1,'VOEVV',1,null))no_nh_viet_vets,
345: 'TRANSFER_NO_NH_OT_EV=P',
346: nvl(count(decode(peo.per_information5,'OTEV',1,'OTEDV',1,'DVOEV',1,'VOEVV',1,null)),0)
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

Line 431: FROM per_assignments_f ass,

427:
428: cursor S_VETC_ASG_COUNT is
429: SELECT 'TRANSFER_COUNT_ASSIGNMENTS=P',
430: count(ass.assignment_id)
431: FROM per_assignments_f ass,
432: hr_establishments_v hev,
433: hr_locations hl,
434: pay_state_rules psr,
435: hr_organization_information hoi1,

Line 495: per_assignments_f ass,

491: cursor S_VETC_MIN_COUNT is
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')