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_NO_ABSENCE dependencies on PER_ABSENCE_ATTENDANCES

Line 79: FROM per_absence_attendances paa, per_absence_attendance_types pat

75: SELECT paa.absence_attendance_id
76: ,paa.date_start
77: ,paa.date_end,
78: DECODE(paa.date_start, paa.date_end, 1, (paa.date_end-paa.date_start)+1) AS days_diff
79: FROM per_absence_attendances paa, per_absence_attendance_types pat
80: WHERE paa.person_id = l_person_id
81: AND paa.date_start < p_abs_start_date
82: AND paa.date_end < p_abs_start_date
83: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 185: FROM per_absence_attendances paa, per_absence_attendance_types pat

181: SELECT paa.absence_attendance_id
182: ,paa.date_start
183: ,paa.date_end,
184: DECODE(paa.date_start, paa.date_end, 1, (paa.date_end-paa.date_start)+1) AS days_diff
185: FROM per_absence_attendances paa, per_absence_attendance_types pat
186: WHERE paa.person_id = l_person_id
187: AND paa.date_start < p_abs_start_date
188: AND paa.date_end < p_abs_start_date
189: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 199: PER_ABSENCE_ATTENDANCES paa

195: CURSOR csr_get_intial_abs_st_date( p_intial_abs_attend_id IN NUMBER ) IS
196: SELECT
197: paa.date_start
198: FROM
199: PER_ABSENCE_ATTENDANCES paa
200: WHERE
201: PAA.ABSENCE_ATTENDANCE_ID = p_intial_abs_attend_id;
202:
203: /* Cursor to get the initial absence start date for sickness */

Line 648: FROM PER_ABSENCE_ATTENDANCES PAA

644: ,l_abs_restrict_empr_sl
645: ,l_abs_restrict_ss_sl
646: ,l_follow_sent
647: ,l_abs_daily_rate
648: FROM PER_ABSENCE_ATTENDANCES PAA
649: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
650: EXCEPTION
651: WHEN OTHERS THEN
652: l_cert_type := null;

Line 692: FROM PER_ABSENCE_ATTENDANCES PAA

688: ,l_abs_restrict_empr_sl
689: ,l_abs_restrict_ss_sl
690: ,l_follow_sent
691: ,l_abs_daily_rate
692: FROM PER_ABSENCE_ATTENDANCES PAA
693: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
694: EXCEPTION
695: WHEN OTHERS THEN
696: l_cert_type := null;

Line 746: FROM PER_ABSENCE_ATTENDANCES PAA

742: IF l_abs_category_code IN ('S','PTS') AND l_cert_type = 'SC' THEN
743: BEGIN
744: SELECT SUM( PAA.DATE_END - PAA.DATE_START )
745: INTO l_abs_count
746: FROM PER_ABSENCE_ATTENDANCES PAA
747: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id
748: AND PAA.DATE_END BETWEEN (p_abs_start_date - (p_abs_link_period+1)) AND (p_abs_start_date -1)
749: AND PAA.ABS_INFORMATION1 = 'SC'
750: AND PAA.DATE_START IS NOT NULL

Line 774: FROM PER_ABSENCE_ATTENDANCES PAA

770: IF l_abs_category_code IN ('S','PTS') AND l_cert_type = 'SC' THEN
771: BEGIN
772: SELECT count(1)
773: INTO l_abs_count
774: FROM PER_ABSENCE_ATTENDANCES PAA
775: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id
776: AND PAA.DATE_END BETWEEN add_months(p_abs_start_date, -12) AND (p_abs_start_date-1)
777: AND PAA.ABS_INFORMATION1 = 'SC'
778: AND PAA.DATE_START IS NOT NULL

Line 802: ,PER_ABSENCE_ATTENDANCES PAA

798: BEGIN
799: SELECT LKP.Meaning
800: INTO l_abs_reason
801: FROM FND_LOOKUP_VALUES LKP
802: ,PER_ABSENCE_ATTENDANCES PAA
803: ,PER_ABS_ATTENDANCE_REASONS PAR
804: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAR.ABSENCE_ATTENDANCE_TYPE_ID
805: AND PAA.ABS_ATTENDANCE_REASON_ID = PAR.ABS_ATTENDANCE_REASON_ID
806: AND PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id

Line 829: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT

825: WHEN PAA.DATE_START = PAA.DATE_END THEN
826: 1
827: ELSE (PAA.DATE_END - PAA.DATE_START) END ) AS DAYS
828: INTO l_abs_unauthor
829: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT
830: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAT.ABSENCE_ATTENDANCE_TYPE_ID
831: AND PAT.ABSENCE_CATEGORY = 'UN'
832: AND PAA.DATE_START <= l_dateofjoin_28
833: AND PAA.DATE_END >= l_dateofjoin

Line 843: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT

839: WHEN PAA.DATE_START = PAA.DATE_END THEN
840: 1
841: ELSE (PAA.DATE_END - PAA.DATE_START) + 1 END ) AS DAYS
842: INTO l_abs_unauthor
843: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT
844: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAT.ABSENCE_ATTENDANCE_TYPE_ID
845: AND PAT.ABSENCE_CATEGORY = 'UN'
846: AND PAA.DATE_START <= (p_abs_start_date-1)
847: AND PAA.DATE_END >= l_dateofjoin

Line 872: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT

868: -- 14 days within 28 days then no sickness will be paid.
869: BEGIN
870: SELECT COUNT(1)
871: INTO l_abs_count
872: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT
873: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAT.ABSENCE_ATTENDANCE_TYPE_ID
874: AND PAT.ABSENCE_CATEGORY IN ( 'CMS','PA','PTP','M','PTM','IE_AL' ,'PTA')
875: AND PAA.DATE_END BETWEEN (p_abs_start_date - (p_abs_min_gap+1)) AND p_abs_start_date
876: AND ( PAA.DATE_END - PAA.DATE_START ) > p_abs_link_period

Line 2263: FROM per_absence_attendances

2259: WHEN date_end = date_start THEN
2260: 1
2261: ELSE (date_end - date_start) + 1 END ) AS Days_diff
2262: INTO l_abs_worked_days
2263: FROM per_absence_attendances
2264: WHERE person_id = p_person_id
2265: AND date_start < (l_initial_abs_pay_stdt-1)
2266: AND date_end > (l_initial_abs_pay_stdt - p_abs_min_gap)
2267: AND date_start IS NOT NULL

Line 2487: FROM PER_ABSENCE_ATTENDANCES PAA

2483: ,l_abs_restrict_dr_ss
2484: ,l_abs_restrict_empr_sl
2485: ,l_abs_restrict_ss_sl
2486: ,l_abs_daily_rate
2487: FROM PER_ABSENCE_ATTENDANCES PAA
2488: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
2489: EXCEPTION
2490: WHEN OTHERS THEN
2491: l_cert_type := null;

Line 2533: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT

2529: WHEN PAA.DATE_START = PAA.DATE_END THEN
2530: 1
2531: ELSE (PAA.DATE_END - PAA.DATE_START) END ) AS DAYS
2532: INTO l_abs_unauthor
2533: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT
2534: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAT.ABSENCE_ATTENDANCE_TYPE_ID
2535: AND PAT.ABSENCE_CATEGORY = 'UN'
2536: AND PAA.DATE_START <= l_dateofjoin_28
2537: AND PAA.DATE_END >= l_dateofjoin

Line 2547: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT

2543: WHEN PAA.DATE_START = PAA.DATE_END THEN
2544: 1
2545: ELSE (PAA.DATE_END - PAA.DATE_START) + 1 END ) AS DAYS
2546: INTO l_abs_unauthor
2547: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT
2548: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAT.ABSENCE_ATTENDANCE_TYPE_ID
2549: AND PAT.ABSENCE_CATEGORY = 'UN'
2550: AND PAA.DATE_START <= (p_abs_start_date-1)
2551: AND PAA.DATE_END >= l_dateofjoin

Line 2574: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT

2570: -- 14 days within 28 days then no Child Minder Sickness will be paid.
2571: BEGIN
2572: SELECT COUNT(1)
2573: INTO l_abs_count
2574: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT
2575: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAT.ABSENCE_ATTENDANCE_TYPE_ID
2576: AND PAT.ABSENCE_CATEGORY IN ( 'S','PTS','PA','PTP','M','PTM','IE_AL','PTA' )
2577: AND PAA.DATE_END BETWEEN (p_abs_start_date - (p_abs_min_gap+1)) AND p_abs_start_date
2578: AND ( PAA.DATE_END - PAA.DATE_START ) > p_abs_link_period

Line 3615: FROM per_absence_attendances

3611: WHEN date_end = date_start THEN
3612: 1
3613: ELSE (date_end - date_start) + 1 END ) AS Days_diff
3614: INTO l_abs_worked_days
3615: FROM per_absence_attendances
3616: WHERE person_id = p_person_id
3617: AND date_start < (l_initial_abs_pay_stdt-1)
3618: AND date_end > (l_initial_abs_pay_stdt - p_abs_min_gap)
3619: AND date_start IS NOT NULL

Line 3764: FROM PER_ABSENCE_ATTENDANCES PAA

3760: ,l_p_hol_acc_ent
3761: ,l_p_daily_rate_calc
3762: ,l_initial_absence
3763: ,l_initial_abs_attend_id
3764: FROM PER_ABSENCE_ATTENDANCES PAA
3765: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
3766:
3767: EXCEPTION
3768: WHEN OTHERS THEN

Line 3823: FROM per_absence_attendances paa, per_absence_attendance_types pat

3819: BEGIN
3820: SELECT SUM(DECODE(paa.date_start, paa.date_end, 1,
3821: get_weekdays(greatest(p_pay_start_date, paa.date_start), paa.date_end, p_work_pattern) )) AS days_diff
3822: INTO l_paternity_sum
3823: FROM per_absence_attendances paa, per_absence_attendance_types pat
3824: WHERE paa.person_id = p_person_id
3825: AND paa.date_end BETWEEN p_pay_start_date AND p_pay_end_date
3826: AND paa.date_end < p_abs_start_date
3827: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 4039: FROM per_absence_attendances

4035: WHEN date_end = date_start THEN
4036: 1
4037: ELSE (date_end - date_start) + 1 END ) AS Days_diff
4038: INTO l_abs_worked_days
4039: FROM per_absence_attendances
4040: WHERE person_id = p_person_id
4041: AND date_start < (l_initial_abs_pay_stdt-1)
4042: AND date_end > (l_initial_abs_pay_stdt - p_abs_min_gap)
4043: AND date_start IS NOT NULL

Line 4208: FROM PER_ABSENCE_ATTENDANCES PAA

4204: ,l_ptp_hol_acc_ent
4205: ,l_ptp_daily_rate_calc
4206: ,l_initial_absence
4207: ,l_initial_abs_attend_id
4208: FROM PER_ABSENCE_ATTENDANCES PAA
4209: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
4210:
4211: EXCEPTION
4212: WHEN OTHERS THEN

Line 4272: FROM per_absence_attendances paa, per_absence_attendance_types pat

4268: BEGIN
4269: SELECT SUM(DECODE(paa.date_start, paa.date_end, 1,
4270: get_weekdays(greatest(p_pay_start_date, paa.date_start), paa.date_end, p_work_pattern) )) AS days_diff
4271: INTO l_pt_paternity_sum
4272: FROM per_absence_attendances paa, per_absence_attendance_types pat
4273: WHERE paa.person_id = p_person_id
4274: AND paa.date_end BETWEEN p_pay_start_date AND p_pay_end_date
4275: AND paa.date_end < p_abs_start_date
4276: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 4504: FROM per_absence_attendances

4500: WHEN date_end = date_start THEN
4501: 1
4502: ELSE (date_end - date_start) + 1 END ) AS Days_diff
4503: INTO l_abs_worked_days
4504: FROM per_absence_attendances
4505: WHERE person_id = p_person_id
4506: AND date_start < (l_initial_abs_pay_stdt-1)
4507: AND date_end > (l_initial_abs_pay_stdt - p_abs_min_gap)
4508: AND date_start IS NOT NULL

Line 4681: FROM PER_ABSENCE_ATTENDANCES PAA

4677: ,l_m_daily_rate_calc
4678: ,l_m_date_stillborn
4679: ,l_initial_absence
4680: ,l_initial_abs_attend_id
4681: FROM PER_ABSENCE_ATTENDANCES PAA
4682: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
4683: EXCEPTION
4684: WHEN OTHERS THEN
4685:

Line 4746: FROM per_absence_attendances paa, per_absence_attendance_types pat

4742: BEGIN
4743: SELECT SUM(DECODE(paa.date_start, paa.date_end, 1,
4744: get_weekdays(greatest(p_pay_start_date, paa.date_start), paa.date_end, p_work_pattern) )) AS days_diff
4745: INTO l_maternity_sum
4746: FROM per_absence_attendances paa, per_absence_attendance_types pat
4747: WHERE paa.person_id = p_person_id
4748: AND paa.date_end BETWEEN p_pay_start_date AND p_pay_end_date
4749: AND paa.date_end < p_abs_start_date
4750: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 4968: FROM per_absence_attendances

4964: WHEN date_end = date_start THEN
4965: 1
4966: ELSE (date_end - date_start) + 1 END ) AS Days_diff
4967: INTO l_abs_worked_days
4968: FROM per_absence_attendances
4969: WHERE person_id = p_person_id
4970: AND date_start < (l_initial_abs_pay_stdt-1)
4971: AND date_end > (l_initial_abs_pay_stdt - p_abs_min_gap)
4972: AND date_start IS NOT NULL

Line 5143: FROM PER_ABSENCE_ATTENDANCES PAA

5139: ,l_ptm_hol_acc_ent
5140: ,l_ptm_daily_rate_calc
5141: ,l_initial_absence
5142: ,l_initial_abs_attend_id
5143: FROM PER_ABSENCE_ATTENDANCES PAA
5144: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
5145:
5146: EXCEPTION
5147: WHEN OTHERS THEN

Line 5204: FROM per_absence_attendances paa, per_absence_attendance_types pat

5200: BEGIN
5201: SELECT SUM(DECODE(paa.date_start, paa.date_end, 1,
5202: get_weekdays(greatest(p_pay_start_date, paa.date_start), paa.date_end, p_work_pattern) )) AS days_diff
5203: INTO l_pt_maternity_sum
5204: FROM per_absence_attendances paa, per_absence_attendance_types pat
5205: WHERE paa.person_id = p_person_id
5206: AND paa.date_end BETWEEN p_pay_start_date AND p_pay_end_date
5207: AND paa.date_end < p_abs_start_date
5208: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 5438: FROM per_absence_attendances

5434: WHEN date_end = date_start THEN
5435: 1
5436: ELSE (date_end - date_start) + 1 END ) AS Days_diff
5437: INTO l_abs_worked_days
5438: FROM per_absence_attendances
5439: WHERE person_id = p_person_id
5440: AND date_start < (l_initial_abs_pay_stdt-1)
5441: AND date_end > (l_initial_abs_pay_stdt - p_abs_min_gap)
5442: AND date_start IS NOT NULL

Line 5606: FROM PER_ABSENCE_ATTENDANCES PAA

5602: ,l_adopt_comprate
5603: ,l_abs_restrict_dr_ss
5604: ,l_abs_daily_rate
5605: ,l_dummy
5606: FROM PER_ABSENCE_ATTENDANCES PAA
5607: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
5608:
5609: EXCEPTION
5610: WHEN OTHERS THEN

Line 5644: FROM PER_ABSENCE_ATTENDANCES PAA

5640: ,l_abs_daily_rate
5641: ,l_no_of_children
5642: ,l_initial_absence
5643: ,l_initial_abs_attend_id
5644: FROM PER_ABSENCE_ATTENDANCES PAA
5645: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
5646:
5647: EXCEPTION
5648: WHEN OTHERS THEN

Line 5720: FROM per_absence_attendances paa, per_absence_attendance_types pat

5716: BEGIN
5717: SELECT SUM(DECODE(paa.date_start, paa.date_end, 1,
5718: get_weekdays(greatest(p_pay_start_date, paa.date_start), paa.date_end, p_work_pattern) )) AS days_diff
5719: INTO l_adopt_sum
5720: FROM per_absence_attendances paa, per_absence_attendance_types pat
5721: WHERE paa.person_id = p_person_id
5722: AND paa.date_end BETWEEN p_pay_start_date AND p_pay_end_date
5723: AND paa.date_end < p_abs_start_date
5724: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 5955: FROM per_absence_attendances

5951: WHEN date_end = date_start THEN
5952: 1
5953: ELSE (date_end - date_start) + 1 END ) AS Days_diff
5954: INTO l_abs_worked_days
5955: FROM per_absence_attendances
5956: WHERE person_id = p_person_id
5957: AND date_start < (l_initial_abs_pay_stdt-1)
5958: AND date_end > (l_initial_abs_pay_stdt - p_abs_min_gap)
5959: AND date_start IS NOT NULL

Line 6116: FROM PER_ABSENCE_ATTENDANCES PAA

6112: ,l_adopt_reimb_ss
6113: ,l_adopt_restrict_dr_ss
6114: ,l_adopt_restrict_empr_sl
6115: ,l_adopt_daily_rate
6116: FROM PER_ABSENCE_ATTENDANCES PAA
6117: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
6118:
6119: EXCEPTION
6120: WHEN OTHERS THEN

Line 6155: FROM PER_ABSENCE_ATTENDANCES PAA

6151: ,l_adopt_daily_rate
6152: ,l_no_of_children
6153: ,l_initial_absence
6154: ,l_initial_abs_attend_id
6155: FROM PER_ABSENCE_ATTENDANCES PAA
6156: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
6157:
6158: EXCEPTION
6159: WHEN OTHERS THEN

Line 6232: FROM per_absence_attendances paa, per_absence_attendance_types pat

6228: BEGIN
6229: SELECT SUM(DECODE(paa.date_start, paa.date_end, 1,
6230: get_weekdays(greatest(p_pay_start_date, paa.date_start), paa.date_end, p_work_pattern) )) AS days_diff
6231: INTO l_adopt_sum
6232: FROM per_absence_attendances paa, per_absence_attendance_types pat
6233: WHERE paa.person_id = p_person_id
6234: AND paa.date_end BETWEEN p_pay_start_date AND p_pay_end_date
6235: AND paa.date_end < p_abs_start_date
6236: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 6489: FROM per_absence_attendances

6485: WHEN date_end = date_start THEN
6486: 1
6487: ELSE (date_end - date_start) + 1 END ) AS Days_diff
6488: INTO l_abs_worked_days
6489: FROM per_absence_attendances
6490: WHERE person_id = p_person_id
6491: AND date_start < (l_initial_abs_pay_stdt-1)
6492: AND date_end > (l_initial_abs_pay_stdt - p_abs_min_gap)
6493: AND date_start IS NOT NULL

Line 7402: per_absence_attendances

7398: AND asgmt.person_id = pap.person_id;
7399:
7400: CURSOR csr_get_maternity_sd(p_person_id NUMBER, p_dob VARCHAR2 ) IS
7401: SELECT min(date_start) from
7402: per_absence_attendances
7403: where person_id = p_person_id
7404: AND ABS_INFORMATION_CATEGORY = 'NO_M'
7405: AND abs_information2 = p_dob;
7406:

Line 7409: per_absence_attendances

7405: AND abs_information2 = p_dob;
7406:
7407: CURSOR csr_get_baby_dob(p_abs_attendance_id NUMBER) IS
7408: SELECT abs_information2 from
7409: per_absence_attendances
7410: WHERE ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
7411:
7412: CURSOR csr_get_element_type_id(p_element_entry_id NUMBER) IS
7413: SELECT element_type_id from

Line 7489: per_absence_attendances

7485:
7486: /*
7487: CURSOR csr_get_adoption_sd(p_person_id NUMBER, p_dob VARCHAR2 ) IS
7488: SELECT min(date_start) from
7489: per_absence_attendances
7490: where person_id = p_person_id
7491: AND ABS_INFORMATION_CATEGORY = 'NO_IE_AL'
7492: AND abs_information2 = p_dob;
7493: */

Line 7497: per_absence_attendances

7493: */
7494:
7495: CURSOR csr_get_adoption_sd(p_person_id NUMBER, p_dob VARCHAR2 ) IS
7496: SELECT min(date_start) from
7497: per_absence_attendances
7498: where person_id = p_person_id
7499: AND ABS_INFORMATION_CATEGORY IN ('NO_IE_AL','NO_PTA')
7500: AND abs_information2 = p_dob;
7501:

Line 7507: per_absence_attendances

7503:
7504:
7505: CURSOR csr_get_baby_dob(p_abs_attendance_id NUMBER) IS
7506: SELECT abs_information2 from
7507: per_absence_attendances
7508: WHERE ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
7509:
7510: CURSOR csr_get_element_type_id(p_element_entry_id NUMBER) IS
7511: SELECT element_type_id from

Line 7737: FROM PER_ABSENCE_ATTENDANCES PAA

7733: p_hol_days OUT nocopy NUMBER ) RETURN NUMBER IS
7734:
7735: CURSOR csr_mat_get_hol_days IS
7736: SELECT paa.abs_information14 hol_days
7737: FROM PER_ABSENCE_ATTENDANCES PAA
7738: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
7739:
7740: CURSOR csr_pt_mat_get_hol_days IS
7741: SELECT paa.abs_information13 hol_days

Line 7742: FROM PER_ABSENCE_ATTENDANCES PAA

7738: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
7739:
7740: CURSOR csr_pt_mat_get_hol_days IS
7741: SELECT paa.abs_information13 hol_days
7742: FROM PER_ABSENCE_ATTENDANCES PAA
7743: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
7744:
7745: CURSOR csr_pat_get_hol_days IS
7746: SELECT paa.abs_information10 hol_days

Line 7747: FROM PER_ABSENCE_ATTENDANCES PAA

7743: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
7744:
7745: CURSOR csr_pat_get_hol_days IS
7746: SELECT paa.abs_information10 hol_days
7747: FROM PER_ABSENCE_ATTENDANCES PAA
7748: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
7749:
7750: CURSOR csr_pt_pat_get_hol_days IS
7751: SELECT paa.abs_information12 hol_days

Line 7752: FROM PER_ABSENCE_ATTENDANCES PAA

7748: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
7749:
7750: CURSOR csr_pt_pat_get_hol_days IS
7751: SELECT paa.abs_information12 hol_days
7752: FROM PER_ABSENCE_ATTENDANCES PAA
7753: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
7754:
7755: BEGIN
7756:

Line 7875: FROM per_absence_attendances

7871: FUNCTION get_abs_st_date (p_abs_attendance_id IN NUMBER) RETURN DATE IS
7872:
7873: CURSOR csr_get_abs_st_date(p_abs_attn_id IN VARCHAR2 ) IS
7874: SELECT date_start
7875: FROM per_absence_attendances
7876: WHERE absence_attendance_id = p_abs_attn_id ;
7877:
7878: l_abs_st_date DATE ;
7879: