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_SE_HOLIDAY_PAY dependencies on PER_ALL_ASSIGNMENTS_F

Line 40: FROM PER_ALL_ASSIGNMENTS_F ASG

36: ,HR_ORGANIZATION_INFORMATION hoi2
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

Line 81: FROM per_all_assignments_f asg

77: ,hr_organization_information hoi2
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

Line 105: FROM per_all_assignments_f asg1

101:
102: CURSOR csr_attendance_type_id
103: IS
104: SELECT DISTINCT eev1.screen_entry_value attendance_type_id
105: FROM per_all_assignments_f asg1
106: --,per_all_assignments_f asg2
107: -- ,per_all_people_f per
108: , pay_element_links_f el
109: ,pay_element_types_f et

Line 106: --,per_all_assignments_f asg2

102: CURSOR csr_attendance_type_id
103: IS
104: SELECT DISTINCT eev1.screen_entry_value attendance_type_id
105: FROM per_all_assignments_f asg1
106: --,per_all_assignments_f asg2
107: -- ,per_all_people_f per
108: , pay_element_links_f el
109: ,pay_element_types_f et
110: ,pay_input_values_f iv1

Line 166: FROM per_all_assignments_f asg

162: ,hr_organization_information hoi2
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

Line 188: per_all_assignments_f

184: AND hoi4.org_information_context = 'SE_HOLIDAY_YEAR_DEFN'
185: AND hoi4.org_information1 IS NOT NULL;
186: /*CURSOR csr_assignment_start IS
187: SELECT min(EFFECTIVE_START_DATE) FROM
188: per_all_assignments_f
189: WHERE assignment_id=p_assignment_id;*/
190: BEGIN
191: SELECT papf.business_group_id
192: ,papf.person_id

Line 195: FROM per_all_assignments_f paaf

191: SELECT papf.business_group_id
192: ,papf.person_id
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

Line 317: FROM per_all_assignments_f asg

313: ,hr_organization_information hoi2
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

Line 341: FROM per_all_assignments_f

337:
338: CURSOR csr_assignment_start
339: IS
340: SELECT MIN (effective_start_date)
341: FROM per_all_assignments_f
342: WHERE assignment_id = p_assignment_id;
343: BEGIN
344: SELECT papf.business_group_id
345: INTO l_business_group_id

Line 346: FROM per_all_assignments_f paaf

342: WHERE assignment_id = p_assignment_id;
343: BEGIN
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

Line 465: FROM PER_ALL_ASSIGNMENTS_F ASG

461: ,HR_ORGANIZATION_INFORMATION hoi2
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

Line 506: FROM per_all_assignments_f asg

502: ,hr_organization_information hoi2
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

Line 530: FROM per_all_assignments_f asg1

526:
527: CURSOR csr_attendance_category_id
528: IS
529: SELECT DISTINCT eev1.screen_entry_value attendance_category_id
530: FROM per_all_assignments_f asg1
531: --,per_all_assignments_f asg2
532: -- ,per_all_people_f per
533: , pay_element_links_f el
534: ,pay_element_types_f et

Line 531: --,per_all_assignments_f asg2

527: CURSOR csr_attendance_category_id
528: IS
529: SELECT DISTINCT eev1.screen_entry_value attendance_category_id
530: FROM per_all_assignments_f asg1
531: --,per_all_assignments_f asg2
532: -- ,per_all_people_f per
533: , pay_element_links_f el
534: ,pay_element_types_f et
535: ,pay_input_values_f iv1

Line 590: FROM per_all_assignments_f asg

586: ,hr_organization_information hoi2
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

Line 615: FROM per_all_assignments_f

611:
612: CURSOR csr_assignment_start
613: IS
614: SELECT MIN (effective_start_date)
615: FROM per_all_assignments_f
616: WHERE assignment_id = p_assignment_id;
617: BEGIN
618: SELECT papf.business_group_id
619: ,papf.person_id

Line 624: FROM per_all_assignments_f paaf

620: ,segment9
621: INTO l_business_group_id
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

Line 792: FROM per_all_assignments_f paaf

788:
789: CURSOR csr_get_vacation_days
790: IS
791: SELECT NVL (SUM (peevf2.screen_entry_value), 0)
792: FROM per_all_assignments_f paaf
793: ,pay_element_types_f et
794: ,pay_element_entries_f ee
795: ,pay_element_entry_values_f peevf1
796: ,pay_element_entry_values_f peevf2

Line 888: FROM per_all_assignments_f asg

884: ,hr_organization_information hoi2
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

Line 913: FROM per_all_assignments_f paaf

909: SELECT papf.business_group_id
910: ,papf.person_id
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

Line 1003: FROM per_all_assignments_f asg

999: ,p_element_name IN VARCHAR2
1000: )
1001: IS
1002: SELECT 1
1003: FROM per_all_assignments_f asg
1004: ,pay_element_links_f el
1005: ,pay_element_types_f et
1006: ,pay_element_entries_f ee
1007: WHERE asg.assignment_id = p_assignment_id

Line 1127: FROM per_all_assignments_f asg

1123: ,hr_organization_information hoi2
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

Line 1171: FROM per_all_assignments_f asg

1167: ,hr_organization_information hoi2
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

Line 1196: FROM per_all_assignments_f paaf

1192: SELECT papf.business_group_id
1193: ,papf.person_id
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

Line 1437: FROM per_all_assignments_f

1433: IS
1434: CURSOR csr_hourly_salaried_code
1435: IS
1436: SELECT NVL (hourly_salaried_code, '##') hsc
1437: FROM per_all_assignments_f
1438: WHERE assignment_id = p_assignment_id_id
1439: AND p_date_earned BETWEEN effective_start_date AND effective_end_date;
1440:
1441: lr_hourly_salaried_code csr_hourly_salaried_code%ROWTYPE;

Line 1566: FROM per_all_assignments_f

1562:
1563: CURSOR csr_assignment_start
1564: IS
1565: SELECT MIN (effective_start_date)
1566: FROM per_all_assignments_f
1567: WHERE assignment_id = p_assignment_id;
1568: BEGIN
1569: --l_year:=GET_END_YEAR(p_date_earned,p_tax_unit_id);
1570: OPEN csr_earning_year;

Line 1641: FROM per_all_assignments_f paaf

1637: IS
1638: CURSOR csr_asg
1639: IS
1640: SELECT paaf.effective_start_date effective_start_date
1641: FROM per_all_assignments_f paaf
1642: WHERE paaf.business_group_id = p_business_group_id
1643: AND paaf.assignment_id = p_asg_id
1644: AND paaf.assignment_status_type_id = 3;
1645:

Line 1709: FROM per_all_assignments_f asg1

1705:
1706: CURSOR csr_attendance_category_id
1707: IS
1708: SELECT DISTINCT eev1.screen_entry_value attendance_category_id
1709: FROM per_all_assignments_f asg1
1710: --,per_all_assignments_f asg2
1711: -- ,per_all_people_f per
1712: , pay_element_links_f el
1713: ,pay_element_types_f et

Line 1710: --,per_all_assignments_f asg2

1706: CURSOR csr_attendance_category_id
1707: IS
1708: SELECT DISTINCT eev1.screen_entry_value attendance_category_id
1709: FROM per_all_assignments_f asg1
1710: --,per_all_assignments_f asg2
1711: -- ,per_all_people_f per
1712: , pay_element_links_f el
1713: ,pay_element_types_f et
1714: ,pay_input_values_f iv1

Line 1750: FROM per_all_assignments_f asg

1746: ,hr_organization_information hoi2
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

Line 1822: FROM per_all_assignments_f asg

1818: ,hr_organization_information hoi2
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

Line 1849: FROM per_all_assignments_f paaf

1845: ,segment9
1846: INTO l_business_group_id
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

Line 2034: FROM per_all_assignments_f asg

2030: ,hr_organization_information hoi2
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

Line 2106: FROM per_all_assignments_f asg

2102: ,hr_organization_information hoi2
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

Line 2204: FROM per_all_assignments_f paaf

2200:
2201: CURSOR csr_assignment_start (csr_v_assignment_id NUMBER)
2202: IS
2203: SELECT MIN (effective_start_date)
2204: FROM per_all_assignments_f paaf
2205: WHERE paaf.assignment_id = csr_v_assignment_id;
2206: BEGIN
2207: OPEN csr_assignment_start (p_assignment_id);
2208:

Line 2280: FROM per_all_assignments_f

2276:
2277: CURSOR csr_assignment_start
2278: IS
2279: SELECT MIN (effective_start_date)
2280: FROM per_all_assignments_f
2281: WHERE assignment_id = p_assignment_id;
2282:
2283: CURSOR csr_payroll_id
2284: IS

Line 2286: FROM per_all_assignments_f

2282:
2283: CURSOR csr_payroll_id
2284: IS
2285: SELECT payroll_id
2286: FROM per_all_assignments_f
2287: WHERE assignment_id = p_assignment_id
2288: AND p_effective_date BETWEEN effective_start_date
2289: AND effective_end_date;
2290:

Line 2437: FROM per_all_assignments_f paaf

2433: CURSOR csr_get_details
2434: IS
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

Line 2552: FROM per_all_assignments_f asg1

2548:
2549: CURSOR csr_attendance_category_id
2550: IS
2551: SELECT DISTINCT eev1.screen_entry_value attendance_category_id
2552: FROM per_all_assignments_f asg1
2553: ,pay_element_links_f el
2554: ,pay_element_types_f et
2555: ,pay_input_values_f iv1
2556: ,pay_element_entries_f ee

Line 2610: FROM per_all_assignments_f

2606:
2607: CURSOR csr_assignment_start
2608: IS
2609: SELECT MIN (effective_start_date)
2610: FROM per_all_assignments_f
2611: WHERE assignment_id = p_assignment_id;
2612: BEGIN
2613: SELECT papf.business_group_id
2614: ,papf.person_id

Line 2619: FROM per_all_assignments_f paaf

2615: ,segment9
2616: INTO l_business_group_id
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

Line 2832: FROM per_all_assignments_f

2828:
2829: CURSOR csr_asg_employee_category (csr_v_effective_date DATE)
2830: IS
2831: SELECT employee_category
2832: FROM per_all_assignments_f
2833: WHERE assignment_id = p_asg_id
2834: AND csr_v_effective_date BETWEEN effective_start_date
2835: AND effective_end_date;
2836: BEGIN

Line 2887: FROM per_all_assignments_f

2883: l_return DATE;
2884: BEGIN
2885: SELECT MIN (effective_start_date)
2886: INTO l_return
2887: FROM per_all_assignments_f
2888: WHERE assignment_id = p_assignment_id;
2889:
2890: RETURN l_return;
2891: END get_min_assignment_start;

Line 2912: FROM per_all_assignments_f paaf

2908: IS
2909: SELECT nvl(TRUNC
2910: (fnd_number.canonical_to_number (segment13)),l_full_time)
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

Line 2958: FROM per_all_assignments_f paaf

2954: ,csr_v_effective_date 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

Line 3091: FROM per_all_assignments_f paaf,

3087: is
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

Line 3114: FROM per_all_assignments_f paaf

3110: , LEAST (paaf.effective_end_date, csr_v_ey_end)
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

Line 3161: FROM per_all_assignments_f

3157:
3158: CURSOR csr_assignment_start
3159: IS
3160: SELECT MIN (effective_start_date)
3161: FROM per_all_assignments_f
3162: WHERE assignment_id = p_assignment_id;
3163:
3164: CURSOR csr_get_dob
3165: IS

Line 3167: FROM per_all_assignments_f paaf

3163:
3164: CURSOR csr_get_dob
3165: IS
3166: SELECT TRUNC (MONTHS_BETWEEN (p_effective_date, papf.date_of_birth))
3167: FROM per_all_assignments_f paaf
3168: ,per_all_people_f papf
3169: WHERE paaf.assignment_id = p_assignment_id
3170: AND papf.person_id = paaf.person_id
3171: AND p_effective_date BETWEEN paaf.effective_start_date

Line 3533: FROM per_all_assignments_f paaf

3529: + 1
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

Line 3618: FROM per_all_assignments_f

3614:
3615: CURSOR csr_assignment_start
3616: IS
3617: SELECT MIN (effective_start_date)
3618: FROM per_all_assignments_f
3619: WHERE assignment_id = p_assignment_id;
3620: BEGIN
3621: l_business_group_id := p_business_group_id;
3622: