[Home] [Help]
37: ,HR_ORGANIZATION_INFORMATION hoi3
38: ,HR_ORGANIZATION_INFORMATION hoi4
39: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
40: FROM PER_ALL_ASSIGNMENTS_F ASG
41: ,HR_SOFT_CODING_KEYFLEX SCL
42: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
43: AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID
44: AND p_effective_date BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE ) X
45: WHERE o1.business_group_id = l_business_group_id
78: ,hr_organization_information hoi3
79: ,hr_organization_information hoi4
80: , (SELECT TRIM (scl.segment2) AS org_id
81: FROM per_all_assignments_f asg
82: ,hr_soft_coding_keyflex scl
83: WHERE asg.assignment_id = p_assignment_id
84: AND asg.soft_coding_keyflex_id =
85: scl.soft_coding_keyflex_id
86: AND p_effective_date BETWEEN asg.effective_start_date
163: ,hr_organization_information hoi3
164: ,hr_organization_information hoi4
165: , (SELECT TRIM (scl.segment2) AS org_id
166: FROM per_all_assignments_f asg
167: ,hr_soft_coding_keyflex scl
168: WHERE asg.assignment_id = p_assignment_id
169: AND asg.soft_coding_keyflex_id =
170: scl.soft_coding_keyflex_id
171: AND p_effective_date BETWEEN asg.effective_start_date
193: INTO l_business_group_id
194: ,l_person_id
195: FROM per_all_assignments_f paaf
196: ,per_all_people_f papf
197: ,hr_soft_coding_keyflex hsck
198: WHERE paaf.assignment_id = p_assignment_id
199: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
200: AND papf.person_id = paaf.person_id
201: AND p_effective_date BETWEEN paaf.effective_start_date
314: ,hr_organization_information hoi3
315: ,hr_organization_information hoi4
316: , (SELECT TRIM (scl.segment2) AS org_id
317: FROM per_all_assignments_f asg
318: ,hr_soft_coding_keyflex scl
319: WHERE asg.assignment_id = p_assignment_id
320: AND asg.soft_coding_keyflex_id =
321: scl.soft_coding_keyflex_id
322: AND p_effective_date BETWEEN asg.effective_start_date
344: SELECT papf.business_group_id
345: INTO l_business_group_id
346: FROM per_all_assignments_f paaf
347: ,per_all_people_f papf
348: ,hr_soft_coding_keyflex hsck
349: WHERE paaf.assignment_id = p_assignment_id
350: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
351: AND papf.person_id = paaf.person_id
352: AND p_effective_date BETWEEN paaf.effective_start_date
462: ,HR_ORGANIZATION_INFORMATION hoi3
463: ,HR_ORGANIZATION_INFORMATION hoi4
464: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
465: FROM PER_ALL_ASSIGNMENTS_F ASG
466: ,HR_SOFT_CODING_KEYFLEX SCL
467: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
468: AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID
469: AND p_effective_date BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE ) X
470: WHERE o1.business_group_id = l_business_group_id
503: ,hr_organization_information hoi3
504: ,hr_organization_information hoi4
505: , (SELECT TRIM (scl.segment2) AS org_id
506: FROM per_all_assignments_f asg
507: ,hr_soft_coding_keyflex scl
508: WHERE asg.assignment_id = p_assignment_id
509: AND asg.soft_coding_keyflex_id =
510: scl.soft_coding_keyflex_id
511: AND p_effective_date BETWEEN asg.effective_start_date
587: ,hr_organization_information hoi3
588: ,hr_organization_information hoi4
589: , (SELECT TRIM (scl.segment2) AS org_id
590: FROM per_all_assignments_f asg
591: ,hr_soft_coding_keyflex scl
592: WHERE asg.assignment_id = p_assignment_id
593: AND asg.soft_coding_keyflex_id =
594: scl.soft_coding_keyflex_id
595: AND p_effective_date BETWEEN asg.effective_start_date
622: ,l_person_id
623: ,l_working_perc
624: FROM per_all_assignments_f paaf
625: ,per_all_people_f papf
626: ,hr_soft_coding_keyflex hsck
627: WHERE paaf.assignment_id = p_assignment_id --15381
628: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
629: AND papf.person_id = paaf.person_id
630: AND p_effective_date BETWEEN paaf.effective_start_date
885: ,hr_organization_information hoi3
886: ,hr_organization_information hoi4
887: , (SELECT TRIM (scl.segment2) AS org_id
888: FROM per_all_assignments_f asg
889: ,hr_soft_coding_keyflex scl
890: WHERE asg.assignment_id = p_assignment_id
891: AND asg.soft_coding_keyflex_id =
892: scl.soft_coding_keyflex_id
893: AND p_effective_date BETWEEN asg.effective_start_date
911: INTO l_business_group_id
912: ,l_person_id
913: FROM per_all_assignments_f paaf
914: ,per_all_people_f papf
915: ,hr_soft_coding_keyflex hsck
916: WHERE paaf.assignment_id = p_assignment_id --15381
917: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
918: AND papf.person_id = paaf.person_id
919: AND p_effective_date BETWEEN paaf.effective_start_date
1124: ,hr_organization_information hoi3
1125: ,hr_organization_information hoi4
1126: , (SELECT TRIM (scl.segment2) AS org_id
1127: FROM per_all_assignments_f asg
1128: ,hr_soft_coding_keyflex scl
1129: WHERE asg.assignment_id = p_assignment_id
1130: AND asg.soft_coding_keyflex_id =
1131: scl.soft_coding_keyflex_id
1132: AND p_effective_date BETWEEN asg.effective_start_date
1168: ,hr_organization_information hoi3
1169: ,hr_organization_information hoi4
1170: , (SELECT TRIM (scl.segment2) AS org_id
1171: FROM per_all_assignments_f asg
1172: ,hr_soft_coding_keyflex scl
1173: WHERE asg.assignment_id = p_assignment_id
1174: AND asg.soft_coding_keyflex_id =
1175: scl.soft_coding_keyflex_id
1176: AND p_effective_date BETWEEN asg.effective_start_date
1194: INTO l_business_group_id
1195: ,l_person_id
1196: FROM per_all_assignments_f paaf
1197: ,per_all_people_f papf
1198: ,hr_soft_coding_keyflex hsck
1199: WHERE paaf.assignment_id = p_assignment_id --15381
1200: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
1201: AND papf.person_id = paaf.person_id
1202: AND p_effective_date BETWEEN paaf.effective_start_date
1747: ,hr_organization_information hoi3
1748: ,hr_organization_information hoi4
1749: , (SELECT TRIM (scl.segment2) AS org_id
1750: FROM per_all_assignments_f asg
1751: ,hr_soft_coding_keyflex scl
1752: WHERE asg.assignment_id = p_assignment_id
1753: AND asg.soft_coding_keyflex_id =
1754: scl.soft_coding_keyflex_id
1755: AND p_date_earned BETWEEN asg.effective_start_date
1819: ,hr_organization_information hoi3
1820: ,hr_organization_information hoi4
1821: , (SELECT TRIM (scl.segment2) AS org_id
1822: FROM per_all_assignments_f asg
1823: ,hr_soft_coding_keyflex scl
1824: WHERE asg.assignment_id = p_assignment_id
1825: AND asg.soft_coding_keyflex_id =
1826: scl.soft_coding_keyflex_id
1827: AND p_date_earned BETWEEN asg.effective_start_date
1847: ,l_person_id
1848: ,l_working_perc
1849: FROM per_all_assignments_f paaf
1850: ,per_all_people_f papf
1851: ,hr_soft_coding_keyflex hsck
1852: WHERE paaf.assignment_id = p_assignment_id --15381
1853: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
1854: AND papf.person_id = paaf.person_id
1855: AND p_date_earned BETWEEN paaf.effective_start_date
2031: ,hr_organization_information hoi3
2032: ,hr_organization_information hoi4
2033: , (SELECT TRIM (scl.segment2) AS org_id
2034: FROM per_all_assignments_f asg
2035: ,hr_soft_coding_keyflex scl
2036: WHERE asg.assignment_id = p_assignment_id
2037: AND asg.soft_coding_keyflex_id =
2038: scl.soft_coding_keyflex_id
2039: AND p_date_earned BETWEEN asg.effective_start_date
2103: ,hr_organization_information hoi3
2104: ,hr_organization_information hoi4
2105: , (SELECT TRIM (scl.segment2) AS org_id
2106: FROM per_all_assignments_f asg
2107: ,hr_soft_coding_keyflex scl
2108: WHERE asg.assignment_id = p_assignment_id
2109: AND asg.soft_coding_keyflex_id =
2110: scl.soft_coding_keyflex_id
2111: AND p_date_earned BETWEEN asg.effective_start_date
2435: SELECT papf.business_group_id
2436: ,papf.person_id
2437: FROM per_all_assignments_f paaf
2438: ,per_all_people_f papf
2439: ,hr_soft_coding_keyflex hsck
2440: WHERE paaf.assignment_id = p_assignment_id --15381
2441: --AND paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
2442: AND papf.person_id = paaf.person_id
2443: AND p_effective_date BETWEEN paaf.effective_start_date
2617: ,l_person_id
2618: ,l_working_perc
2619: FROM per_all_assignments_f paaf
2620: ,per_all_people_f papf
2621: ,hr_soft_coding_keyflex hsck
2622: WHERE paaf.assignment_id = p_assignment_id
2623: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
2624: AND papf.person_id = paaf.person_id
2625: AND p_effective_date BETWEEN paaf.effective_start_date
2911: /* change this to the field which we are going to add for part time employee */
2912: FROM per_all_assignments_f paaf
2913: ,
2914: -- per_all_people_f papf,
2915: hr_soft_coding_keyflex hsck
2916: WHERE paaf.assignment_id = csr_v_assignment_id --15381
2917: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
2918: --AND papf.person_id=paaf.person_id
2919: AND csr_v_effective_date BETWEEN paaf.effective_start_date
2955: )
2956: IS
2957: SELECT segment12
2958: FROM per_all_assignments_f paaf
2959: ,hr_soft_coding_keyflex hsck
2960: WHERE paaf.assignment_id = csr_v_assignment_id
2961: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
2962: AND csr_v_effective_date BETWEEN paaf.effective_start_date
2963: AND paaf.effective_end_date;
3088: SELECT paaf.business_group_id,
3089: paaf.person_id,
3090: segment9
3091: FROM per_all_assignments_f paaf,
3092: hr_soft_coding_keyflex hsck
3093: WHERE paaf.assignment_id = p_assignment_id --15381
3094: AND paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
3095: AND paaf.effective_start_date <= l_ey_end_date
3096: AND paaf.effective_end_date >= l_ey_start_date;
3111: - GREATEST (paaf.effective_start_date
3112: ,csr_v_ey_start)
3113: + 1 "DAYS"
3114: FROM per_all_assignments_f paaf
3115: ,hr_soft_coding_keyflex hsck
3116: WHERE paaf.assignment_id = p_assignment_id
3117: AND paaf.soft_coding_keyflex_id =
3118: hsck.soft_coding_keyflex_id
3119: AND paaf.effective_start_date <= csr_v_ey_end
3530: )
3531: )
3532: END "IN_HOURS"
3533: FROM per_all_assignments_f paaf
3534: ,hr_soft_coding_keyflex hsck
3535: WHERE paaf.assignment_id = p_assignment_id
3536: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
3537: AND paaf.effective_start_date <= csr_v_ey_end
3538: AND paaf.effective_end_date >= csr_v_ey_start);