eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NL_GENERAL dependencies on PER_ALL_ASSIGNMENTS_F

Line 1670: FROM per_all_assignments_f paf

1666: FUNCTION chk_multiple_assignments(p_effective_date IN DATE
1667: ,p_person_id IN NUMBER) RETURN VARCHAR2 AS
1668: CURSOR get_multiple_assgts IS
1669: SELECT count(DISTINCT paf.assignment_id)
1670: FROM per_all_assignments_f paf
1671: ,per_assignment_status_types pas
1672: WHERE paf.assignment_type = 'E'
1673: AND paf.PERSON_ID = p_person_id
1674: AND p_effective_date between effective_start_date and effective_end_date

Line 2674: per_all_assignments_f paaf

2670: IS
2671: select distinct pra.assignment_id, pra.retro_assignment_id
2672: from
2673: pay_retro_assignments pra,
2674: per_all_assignments_f paaf
2675: where
2676: pra.assignment_id = paaf.assignment_id
2677: and pra.reprocess_date >= fnd_date.canonical_to_date(p_reprocess_date) --from conc parameter
2678: and pra.retro_assignment_action_id IS NULL