[Home] [Help]
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)
154: AND (p_grade_id IS NULL OR asg.grade_id = p_grade_id)
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
175: AND asg.business_group_id + 0 = p_business_group_id
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
194: AND asg.assignment_type = 'E'
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'
211: AND p_period_end_date BETWEEN asg.effective_start_date
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
226: AND asg.effective_end_date
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)
500: and (p_grade_id IS NULL OR asg.grade_id = p_grade_id)
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
522: and asg.business_group_id + 0 = p_business_group_id
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
542: and asg.assignment_type = 'E'
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'
560: and p_period_end_date between asg.effective_start_date and
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
576: asg.effective_end_date
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)
969: and (p_grade_id IS NULL OR asg.grade_id = p_grade_id)
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
991: and asg.business_group_id = p_business_group_id
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
1011: and asg.assignment_type = 'E'
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'
1029: and p_effective_date between asg.effective_start_date and
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
1045: asg.effective_end_date