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.HRI_OLTP_DISC_WRKFRC dependencies on PER_ASSIGNMENTS_F

Line 149: FROM per_assignments_f asg

145: ,p_organization_id NUMBER
146: ,p_position_id NUMBER
147: ,p_period_end_date DATE) is
148: SELECT asg.assignment_id
149: FROM per_assignments_f asg
150: ,per_assignment_status_types ast
151: WHERE p_position_id = asg.position_id
152: AND (p_organization_id IS NULL OR asg.organization_id = p_organization_id)
153: AND (p_job_id IS NULL OR asg.job_id = p_job_id)

Line 170: FROM per_assignments_f asg

166: ,p_job_id NUMBER
167: ,p_organization_id NUMBER
168: ,p_period_end_date DATE) is
169: SELECT asg.assignment_id
170: FROM per_assignments_f asg
171: ,per_assignment_status_types ast
172: WHERE (p_organization_id IS NULL OR asg.organization_id = p_organization_id)
173: AND (p_job_id IS NULL OR asg.job_id = p_job_id)
174: AND p_grade_id = asg.grade_id

Line 189: FROM per_assignments_f asg

185: ,p_job_id NUMBER
186: ,p_organization_id NUMBER
187: ,p_period_end_date DATE) is
188: SELECT asg.assignment_id
189: FROM per_assignments_f asg
190: ,per_assignment_status_types ast
191: WHERE (p_organization_id IS NULL OR asg.organization_id = p_organization_id)
192: AND p_job_id = asg.job_id
193: AND asg.business_group_id + 0 = p_business_group_id

Line 206: FROM per_assignments_f asg

202: p_business_group_id NUMBER
203: ,p_organization_id NUMBER
204: ,p_period_end_date DATE) is
205: SELECT asg.assignment_id
206: FROM per_assignments_f asg
207: ,per_assignment_status_types ast
208: WHERE p_organization_id = asg.organization_id
209: AND asg.business_group_id + 0 = p_business_group_id
210: AND asg.assignment_type = 'E'

Line 221: FROM per_assignments_f asg

217: CURSOR bgr_assignment_csr(
218: p_business_group_id NUMBER
219: ,p_period_end_date DATE) is
220: SELECT asg.assignment_id
221: FROM per_assignments_f asg
222: ,per_assignment_status_types ast
223: WHERE asg.business_group_id = p_business_group_id
224: AND asg.assignment_type = 'E'
225: AND p_period_end_date BETWEEN asg.effective_start_date

Line 495: from per_assignments_f asg

491: ,p_position_id NUMBER
492: ,p_period_end_date DATE
493: ) is
494: select asg.assignment_id
495: from per_assignments_f asg
496: ,per_assignment_status_types ast
497: where (p_organization_id IS NULL OR asg.organization_id = p_organization_id)
498: and p_position_id = asg.position_id
499: and (p_job_id IS NULL OR asg.job_id = p_job_id)

Line 517: from per_assignments_f asg

513: ,p_organization_id NUMBER
514: ,p_period_end_date DATE
515: ) is
516: select asg.assignment_id
517: from per_assignments_f asg
518: ,per_assignment_status_types ast
519: where (p_organization_id IS NULL OR asg.organization_id = p_organization_id)
520: and (p_job_id IS NULL OR asg.job_id = p_job_id)
521: and p_grade_id = asg.grade_id

Line 537: from per_assignments_f asg

533: ,p_organization_id NUMBER
534: ,p_period_end_date DATE
535: ) is
536: select asg.assignment_id
537: from per_assignments_f asg
538: ,per_assignment_status_types ast
539: where (p_organization_id IS NULL OR asg.organization_id = p_organization_id)
540: and p_job_id = asg.job_id
541: and asg.business_group_id + 0 = p_business_group_id

Line 555: from per_assignments_f asg

551: ,p_organization_id NUMBER
552: ,p_period_end_date DATE
553: ) is
554: select asg.assignment_id
555: from per_assignments_f asg
556: ,per_assignment_status_types ast
557: where p_organization_id = asg.organization_id
558: and asg.business_group_id + 0 = p_business_group_id
559: and asg.assignment_type = 'E'

Line 571: from per_assignments_f asg

567: p_business_group_id NUMBER
568: ,p_period_end_date DATE
569: ) is
570: select asg.assignment_id
571: from per_assignments_f asg
572: ,per_assignment_status_types ast
573: where asg.business_group_id = p_business_group_id
574: and asg.assignment_type = 'E'
575: and p_period_end_date between asg.effective_start_date and

Line 964: from per_assignments_f asg

960: ,p_position_id NUMBER
961: ,p_effective_date DATE
962: ) is
963: select asg.assignment_id
964: from per_assignments_f asg
965: ,per_assignment_status_types ast
966: where (p_organization_id IS NULL OR asg.organization_id = p_organization_id)
967: and p_position_id = asg.position_id
968: and (p_job_id IS NULL OR asg.job_id = p_job_id)

Line 986: from per_assignments_f asg

982: ,p_organization_id NUMBER
983: ,p_effective_date DATE
984: ) is
985: select asg.assignment_id
986: from per_assignments_f asg
987: ,per_assignment_status_types ast
988: where (p_organization_id IS NULL OR asg.organization_id = p_organization_id)
989: and (p_job_id IS NULL OR asg.job_id = p_job_id)
990: and p_grade_id = asg.grade_id

Line 1006: from per_assignments_f asg

1002: ,p_organization_id NUMBER
1003: ,p_effective_date DATE
1004: ) is
1005: select asg.assignment_id
1006: from per_assignments_f asg
1007: ,per_assignment_status_types ast
1008: where (p_organization_id IS NULL OR asg.organization_id = p_organization_id)
1009: and p_job_id = asg.job_id
1010: and asg.business_group_id = p_business_group_id

Line 1024: from per_assignments_f asg

1020: ,p_organization_id NUMBER
1021: ,p_effective_date DATE
1022: ) is
1023: select asg.assignment_id
1024: from per_assignments_f asg
1025: ,per_assignment_status_types ast
1026: where p_organization_id = asg.organization_id
1027: and asg.business_group_id = p_business_group_id
1028: and asg.assignment_type = 'E'

Line 1040: from per_assignments_f asg

1036: p_business_group_id NUMBER
1037: ,p_effective_date DATE
1038: ) is
1039: select asg.assignment_id
1040: from per_assignments_f asg
1041: ,per_assignment_status_types ast
1042: where asg.business_group_id = p_business_group_id
1043: and asg.assignment_type = 'E'
1044: and p_effective_date between asg.effective_start_date and