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_ASSIGNMENT_STATUS_TYPES

Line 128: per_assignment_status_types past

124: cursor csr_asg_dates is
125: select min(asg.effective_start_date) asg_start_date
126: ,max(asg.effective_end_date) asg_end_date
127: from per_assignments_f asg,
128: per_assignment_status_types past
129: where asg.assignment_id = p_assignment_id
130: and past.per_system_status = 'ACTIVE_ASSIGN'
131: and asg.assignment_status_type_id = past.assignment_status_type_id
132: and asg.effective_start_date <= p_period_end_date

Line 138: per_assignment_status_types past

134:
135: cursor csr_asg_act_dates (p_date date) is
136: select asg.effective_end_date
137: from per_assignments_f asg,
138: per_assignment_status_types past
139: where asg.assignment_id = p_assignment_id
140: and past.per_system_status = 'ACTIVE_ASSIGN'
141: and asg.assignment_status_type_id = past.assignment_status_type_id
142: and asg.effective_start_date =p_date;

Line 1671: ,per_assignment_status_types pas

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
1675: AND paf.assignment_status_type_id = pas.assignment_status_type_id