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 229: from per_absence_attendances A , per_absence_attendances B

225:
226: /*dakhuran, fix for bug no. 15845713, Cursor to count the total absence days in the current payroll period */
227: CURSOR social_security (p_abs_attendance_id NUMBER) IS
228: select (A.DATE_END - (greatest(p_pay_start_date, A.date_start)) + 1)
229: from per_absence_attendances A , per_absence_attendances B
230: where B.absence_attendance_id = p_abs_attendance_id
231: and A.ABSENCE_ATTENDANCE_TYPE_ID = B.ABSENCE_ATTENDANCE_TYPE_ID
232: and A.person_id = B.person_id
233: and A.business_group_id = B.business_group_id

Line 675: FROM PER_ABSENCE_ATTENDANCES PAA

671: ,l_abs_restrict_empr_sl
672: ,l_abs_restrict_ss_sl
673: ,l_follow_sent
674: ,l_abs_daily_rate
675: FROM PER_ABSENCE_ATTENDANCES PAA
676: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
677: EXCEPTION
678: WHEN OTHERS THEN
679: l_cert_type := null;

Line 719: FROM PER_ABSENCE_ATTENDANCES PAA

715: ,l_abs_restrict_empr_sl
716: ,l_abs_restrict_ss_sl
717: ,l_follow_sent
718: ,l_abs_daily_rate
719: FROM PER_ABSENCE_ATTENDANCES PAA
720: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
721: EXCEPTION
722: WHEN OTHERS THEN
723: l_cert_type := null;

Line 773: FROM PER_ABSENCE_ATTENDANCES PAA

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

Line 801: FROM PER_ABSENCE_ATTENDANCES PAA

797: IF l_abs_category_code IN ('S','PTS') AND l_cert_type = 'SC' THEN
798: BEGIN
799: SELECT count(1)
800: INTO l_abs_count
801: FROM PER_ABSENCE_ATTENDANCES PAA
802: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id
803: AND PAA.DATE_END BETWEEN add_months(p_abs_start_date, -12) AND (p_abs_start_date-1)
804: AND PAA.ABS_INFORMATION1 = 'SC'
805: AND PAA.DATE_START IS NOT NULL

Line 829: ,PER_ABSENCE_ATTENDANCES PAA

825: BEGIN
826: SELECT LKP.Meaning
827: INTO l_abs_reason
828: FROM FND_LOOKUP_VALUES LKP
829: ,PER_ABSENCE_ATTENDANCES PAA
830: ,PER_ABS_ATTENDANCE_REASONS PAR
831: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAR.ABSENCE_ATTENDANCE_TYPE_ID
832: AND PAA.ABS_ATTENDANCE_REASON_ID = PAR.ABS_ATTENDANCE_REASON_ID
833: AND PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id

Line 856: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT

852: WHEN PAA.DATE_START = PAA.DATE_END THEN
853: 1
854: ELSE (PAA.DATE_END - PAA.DATE_START) END ) AS DAYS
855: INTO l_abs_unauthor
856: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT
857: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAT.ABSENCE_ATTENDANCE_TYPE_ID
858: AND PAT.ABSENCE_CATEGORY = 'UN'
859: AND PAA.DATE_START <= l_dateofjoin_28
860: AND PAA.DATE_END >= l_dateofjoin

Line 870: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT

866: WHEN PAA.DATE_START = PAA.DATE_END THEN
867: 1
868: ELSE (PAA.DATE_END - PAA.DATE_START) + 1 END ) AS DAYS
869: INTO l_abs_unauthor
870: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT
871: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAT.ABSENCE_ATTENDANCE_TYPE_ID
872: AND PAT.ABSENCE_CATEGORY = 'UN'
873: AND PAA.DATE_START <= (p_abs_start_date-1)
874: AND PAA.DATE_END >= l_dateofjoin

Line 899: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT

895: -- 14 days within 28 days then no sickness will be paid.
896: BEGIN
897: SELECT COUNT(1)
898: INTO l_abs_count
899: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT
900: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAT.ABSENCE_ATTENDANCE_TYPE_ID
901: AND PAT.ABSENCE_CATEGORY IN ( 'CMS','PA','PTP','M','PTM','IE_AL' ,'PTA')
902: AND PAA.DATE_END BETWEEN (p_abs_start_date - (p_abs_min_gap+1)) AND p_abs_start_date
903: AND ( PAA.DATE_END - PAA.DATE_START ) > p_abs_link_period

Line 2307: FROM per_absence_attendances

2303: WHEN date_end = date_start THEN
2304: 1
2305: ELSE (date_end - date_start) + 1 END ) AS Days_diff
2306: INTO l_abs_worked_days
2307: FROM per_absence_attendances
2308: WHERE person_id = p_person_id
2309: AND date_start < (l_initial_abs_pay_stdt-1)
2310: AND date_end > (l_initial_abs_pay_stdt - p_abs_min_gap)
2311: AND date_start IS NOT NULL

Line 2531: FROM PER_ABSENCE_ATTENDANCES PAA

2527: ,l_abs_restrict_dr_ss
2528: ,l_abs_restrict_empr_sl
2529: ,l_abs_restrict_ss_sl
2530: ,l_abs_daily_rate
2531: FROM PER_ABSENCE_ATTENDANCES PAA
2532: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
2533: EXCEPTION
2534: WHEN OTHERS THEN
2535: l_cert_type := null;

Line 2577: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT

2573: WHEN PAA.DATE_START = PAA.DATE_END THEN
2574: 1
2575: ELSE (PAA.DATE_END - PAA.DATE_START) END ) AS DAYS
2576: INTO l_abs_unauthor
2577: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT
2578: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAT.ABSENCE_ATTENDANCE_TYPE_ID
2579: AND PAT.ABSENCE_CATEGORY = 'UN'
2580: AND PAA.DATE_START <= l_dateofjoin_28
2581: AND PAA.DATE_END >= l_dateofjoin

Line 2591: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT

2587: WHEN PAA.DATE_START = PAA.DATE_END THEN
2588: 1
2589: ELSE (PAA.DATE_END - PAA.DATE_START) + 1 END ) AS DAYS
2590: INTO l_abs_unauthor
2591: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT
2592: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAT.ABSENCE_ATTENDANCE_TYPE_ID
2593: AND PAT.ABSENCE_CATEGORY = 'UN'
2594: AND PAA.DATE_START <= (p_abs_start_date-1)
2595: AND PAA.DATE_END >= l_dateofjoin

Line 2618: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT

2614: -- 14 days within 28 days then no Child Minder Sickness will be paid.
2615: BEGIN
2616: SELECT COUNT(1)
2617: INTO l_abs_count
2618: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT
2619: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAT.ABSENCE_ATTENDANCE_TYPE_ID
2620: AND PAT.ABSENCE_CATEGORY IN ( 'S','PTS','PA','PTP','M','PTM','IE_AL','PTA' )
2621: AND PAA.DATE_END BETWEEN (p_abs_start_date - (p_abs_min_gap+1)) AND p_abs_start_date
2622: AND ( PAA.DATE_END - PAA.DATE_START ) > p_abs_link_period

Line 3695: FROM per_absence_attendances

3691: WHEN date_end = date_start THEN
3692: 1
3693: ELSE (date_end - date_start) + 1 END ) AS Days_diff
3694: INTO l_abs_worked_days
3695: FROM per_absence_attendances
3696: WHERE person_id = p_person_id
3697: AND date_start < (l_initial_abs_pay_stdt-1)
3698: AND date_end > (l_initial_abs_pay_stdt - p_abs_min_gap)
3699: AND date_start IS NOT NULL

Line 3844: FROM PER_ABSENCE_ATTENDANCES PAA

3840: ,l_p_hol_acc_ent
3841: ,l_p_daily_rate_calc
3842: ,l_initial_absence
3843: ,l_initial_abs_attend_id
3844: FROM PER_ABSENCE_ATTENDANCES PAA
3845: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
3846:
3847: EXCEPTION
3848: WHEN OTHERS THEN

Line 3903: FROM per_absence_attendances paa, per_absence_attendance_types pat

3899: BEGIN
3900: SELECT SUM(DECODE(paa.date_start, paa.date_end, 1,
3901: get_weekdays(greatest(p_pay_start_date, paa.date_start), paa.date_end, p_work_pattern) )) AS days_diff
3902: INTO l_paternity_sum
3903: FROM per_absence_attendances paa, per_absence_attendance_types pat
3904: WHERE paa.person_id = p_person_id
3905: AND paa.date_end BETWEEN p_pay_start_date AND p_pay_end_date
3906: AND paa.date_end < p_abs_start_date
3907: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 4119: FROM per_absence_attendances

4115: WHEN date_end = date_start THEN
4116: 1
4117: ELSE (date_end - date_start) + 1 END ) AS Days_diff
4118: INTO l_abs_worked_days
4119: FROM per_absence_attendances
4120: WHERE person_id = p_person_id
4121: AND date_start < (l_initial_abs_pay_stdt-1)
4122: AND date_end > (l_initial_abs_pay_stdt - p_abs_min_gap)
4123: AND date_start IS NOT NULL

Line 4289: FROM PER_ABSENCE_ATTENDANCES PAA

4285: ,l_ptp_hol_acc_ent
4286: ,l_ptp_daily_rate_calc
4287: ,l_initial_absence
4288: ,l_initial_abs_attend_id
4289: FROM PER_ABSENCE_ATTENDANCES PAA
4290: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
4291:
4292: EXCEPTION
4293: WHEN OTHERS THEN

Line 4353: FROM per_absence_attendances paa, per_absence_attendance_types pat

4349: BEGIN
4350: SELECT SUM(DECODE(paa.date_start, paa.date_end, 1,
4351: get_weekdays(greatest(p_pay_start_date, paa.date_start), paa.date_end, p_work_pattern) )) AS days_diff
4352: INTO l_pt_paternity_sum
4353: FROM per_absence_attendances paa, per_absence_attendance_types pat
4354: WHERE paa.person_id = p_person_id
4355: AND paa.date_end BETWEEN p_pay_start_date AND p_pay_end_date
4356: AND paa.date_end < p_abs_start_date
4357: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 4585: FROM per_absence_attendances

4581: WHEN date_end = date_start THEN
4582: 1
4583: ELSE (date_end - date_start) + 1 END ) AS Days_diff
4584: INTO l_abs_worked_days
4585: FROM per_absence_attendances
4586: WHERE person_id = p_person_id
4587: AND date_start < (l_initial_abs_pay_stdt-1)
4588: AND date_end > (l_initial_abs_pay_stdt - p_abs_min_gap)
4589: AND date_start IS NOT NULL

Line 4763: FROM PER_ABSENCE_ATTENDANCES PAA

4759: ,l_m_daily_rate_calc
4760: ,l_m_date_stillborn
4761: ,l_initial_absence
4762: ,l_initial_abs_attend_id
4763: FROM PER_ABSENCE_ATTENDANCES PAA
4764: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
4765: EXCEPTION
4766: WHEN OTHERS THEN
4767:

Line 4828: FROM per_absence_attendances paa, per_absence_attendance_types pat

4824: BEGIN
4825: SELECT SUM(DECODE(paa.date_start, paa.date_end, 1,
4826: get_weekdays(greatest(p_pay_start_date, paa.date_start), paa.date_end, p_work_pattern) )) AS days_diff
4827: INTO l_maternity_sum
4828: FROM per_absence_attendances paa, per_absence_attendance_types pat
4829: WHERE paa.person_id = p_person_id
4830: AND paa.date_end BETWEEN p_pay_start_date AND p_pay_end_date
4831: AND paa.date_end < p_abs_start_date
4832: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 5050: FROM per_absence_attendances

5046: WHEN date_end = date_start THEN
5047: 1
5048: ELSE (date_end - date_start) + 1 END ) AS Days_diff
5049: INTO l_abs_worked_days
5050: FROM per_absence_attendances
5051: WHERE person_id = p_person_id
5052: AND date_start < (l_initial_abs_pay_stdt-1)
5053: AND date_end > (l_initial_abs_pay_stdt - p_abs_min_gap)
5054: AND date_start IS NOT NULL

Line 5226: FROM PER_ABSENCE_ATTENDANCES PAA

5222: ,l_ptm_hol_acc_ent
5223: ,l_ptm_daily_rate_calc
5224: ,l_initial_absence
5225: ,l_initial_abs_attend_id
5226: FROM PER_ABSENCE_ATTENDANCES PAA
5227: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
5228:
5229: EXCEPTION
5230: WHEN OTHERS THEN

Line 5287: FROM per_absence_attendances paa, per_absence_attendance_types pat

5283: BEGIN
5284: SELECT SUM(DECODE(paa.date_start, paa.date_end, 1,
5285: get_weekdays(greatest(p_pay_start_date, paa.date_start), paa.date_end, p_work_pattern) )) AS days_diff
5286: INTO l_pt_maternity_sum
5287: FROM per_absence_attendances paa, per_absence_attendance_types pat
5288: WHERE paa.person_id = p_person_id
5289: AND paa.date_end BETWEEN p_pay_start_date AND p_pay_end_date
5290: AND paa.date_end < p_abs_start_date
5291: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 5521: FROM per_absence_attendances

5517: WHEN date_end = date_start THEN
5518: 1
5519: ELSE (date_end - date_start) + 1 END ) AS Days_diff
5520: INTO l_abs_worked_days
5521: FROM per_absence_attendances
5522: WHERE person_id = p_person_id
5523: AND date_start < (l_initial_abs_pay_stdt-1)
5524: AND date_end > (l_initial_abs_pay_stdt - p_abs_min_gap)
5525: AND date_start IS NOT NULL

Line 5690: FROM PER_ABSENCE_ATTENDANCES PAA

5686: ,l_adopt_comprate
5687: ,l_abs_restrict_dr_ss
5688: ,l_abs_daily_rate
5689: ,l_dummy
5690: FROM PER_ABSENCE_ATTENDANCES PAA
5691: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
5692:
5693: EXCEPTION
5694: WHEN OTHERS THEN

Line 5728: FROM PER_ABSENCE_ATTENDANCES PAA

5724: ,l_abs_daily_rate
5725: ,l_no_of_children
5726: ,l_initial_absence
5727: ,l_initial_abs_attend_id
5728: FROM PER_ABSENCE_ATTENDANCES PAA
5729: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
5730:
5731: EXCEPTION
5732: WHEN OTHERS THEN

Line 5804: FROM per_absence_attendances paa, per_absence_attendance_types pat

5800: BEGIN
5801: SELECT SUM(DECODE(paa.date_start, paa.date_end, 1,
5802: get_weekdays(greatest(p_pay_start_date, paa.date_start), paa.date_end, p_work_pattern) )) AS days_diff
5803: INTO l_adopt_sum
5804: FROM per_absence_attendances paa, per_absence_attendance_types pat
5805: WHERE paa.person_id = p_person_id
5806: AND paa.date_end BETWEEN p_pay_start_date AND p_pay_end_date
5807: AND paa.date_end < p_abs_start_date
5808: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 6039: FROM per_absence_attendances

6035: WHEN date_end = date_start THEN
6036: 1
6037: ELSE (date_end - date_start) + 1 END ) AS Days_diff
6038: INTO l_abs_worked_days
6039: FROM per_absence_attendances
6040: WHERE person_id = p_person_id
6041: AND date_start < (l_initial_abs_pay_stdt-1)
6042: AND date_end > (l_initial_abs_pay_stdt - p_abs_min_gap)
6043: AND date_start IS NOT NULL

Line 6201: FROM PER_ABSENCE_ATTENDANCES PAA

6197: ,l_adopt_reimb_ss
6198: ,l_adopt_restrict_dr_ss
6199: ,l_adopt_restrict_empr_sl
6200: ,l_adopt_daily_rate
6201: FROM PER_ABSENCE_ATTENDANCES PAA
6202: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
6203:
6204: EXCEPTION
6205: WHEN OTHERS THEN

Line 6240: FROM PER_ABSENCE_ATTENDANCES PAA

6236: ,l_adopt_daily_rate
6237: ,l_no_of_children
6238: ,l_initial_absence
6239: ,l_initial_abs_attend_id
6240: FROM PER_ABSENCE_ATTENDANCES PAA
6241: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
6242:
6243: EXCEPTION
6244: WHEN OTHERS THEN

Line 6317: FROM per_absence_attendances paa, per_absence_attendance_types pat

6313: BEGIN
6314: SELECT SUM(DECODE(paa.date_start, paa.date_end, 1,
6315: get_weekdays(greatest(p_pay_start_date, paa.date_start), paa.date_end, p_work_pattern) )) AS days_diff
6316: INTO l_adopt_sum
6317: FROM per_absence_attendances paa, per_absence_attendance_types pat
6318: WHERE paa.person_id = p_person_id
6319: AND paa.date_end BETWEEN p_pay_start_date AND p_pay_end_date
6320: AND paa.date_end < p_abs_start_date
6321: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 6574: FROM per_absence_attendances

6570: WHEN date_end = date_start THEN
6571: 1
6572: ELSE (date_end - date_start) + 1 END ) AS Days_diff
6573: INTO l_abs_worked_days
6574: FROM per_absence_attendances
6575: WHERE person_id = p_person_id
6576: AND date_start < (l_initial_abs_pay_stdt-1)
6577: AND date_end > (l_initial_abs_pay_stdt - p_abs_min_gap)
6578: AND date_start IS NOT NULL

Line 7502: per_absence_attendances

7498: AND asgmt.person_id = pap.person_id;
7499:
7500: CURSOR csr_get_maternity_sd(p_person_id NUMBER, p_dob VARCHAR2 ) IS
7501: SELECT min(date_start) from
7502: per_absence_attendances
7503: where person_id = p_person_id
7504: AND ABS_INFORMATION_CATEGORY = 'NO_M'
7505: AND abs_information2 = p_dob;
7506:

Line 7509: per_absence_attendances

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

Line 7589: per_absence_attendances

7585:
7586: /*
7587: CURSOR csr_get_adoption_sd(p_person_id NUMBER, p_dob VARCHAR2 ) IS
7588: SELECT min(date_start) from
7589: per_absence_attendances
7590: where person_id = p_person_id
7591: AND ABS_INFORMATION_CATEGORY = 'NO_IE_AL'
7592: AND abs_information2 = p_dob;
7593: */

Line 7597: per_absence_attendances

7593: */
7594:
7595: CURSOR csr_get_adoption_sd(p_person_id NUMBER, p_dob VARCHAR2 ) IS
7596: SELECT min(date_start) from
7597: per_absence_attendances
7598: where person_id = p_person_id
7599: AND ABS_INFORMATION_CATEGORY IN ('NO_IE_AL','NO_PTA')
7600: AND abs_information2 = p_dob;
7601:

Line 7607: per_absence_attendances

7603:
7604:
7605: CURSOR csr_get_baby_dob(p_abs_attendance_id NUMBER) IS
7606: SELECT abs_information2 from
7607: per_absence_attendances
7608: WHERE ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
7609:
7610: CURSOR csr_get_element_type_id(p_element_entry_id NUMBER) IS
7611: SELECT element_type_id from

Line 7842: FROM PER_ABSENCE_ATTENDANCES PAA

7838: p_hol_days OUT nocopy NUMBER ) RETURN NUMBER IS
7839:
7840: CURSOR csr_mat_get_hol_days IS
7841: SELECT paa.abs_information14 hol_days
7842: FROM PER_ABSENCE_ATTENDANCES PAA
7843: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
7844:
7845: CURSOR csr_pt_mat_get_hol_days IS
7846: SELECT paa.abs_information13 hol_days

Line 7847: FROM PER_ABSENCE_ATTENDANCES PAA

7843: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
7844:
7845: CURSOR csr_pt_mat_get_hol_days IS
7846: SELECT paa.abs_information13 hol_days
7847: FROM PER_ABSENCE_ATTENDANCES PAA
7848: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
7849:
7850: CURSOR csr_pat_get_hol_days IS
7851: SELECT paa.abs_information10 hol_days

Line 7852: FROM PER_ABSENCE_ATTENDANCES PAA

7848: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
7849:
7850: CURSOR csr_pat_get_hol_days IS
7851: SELECT paa.abs_information10 hol_days
7852: FROM PER_ABSENCE_ATTENDANCES PAA
7853: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
7854:
7855: CURSOR csr_pt_pat_get_hol_days IS
7856: SELECT paa.abs_information12 hol_days

Line 7857: FROM PER_ABSENCE_ATTENDANCES PAA

7853: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
7854:
7855: CURSOR csr_pt_pat_get_hol_days IS
7856: SELECT paa.abs_information12 hol_days
7857: FROM PER_ABSENCE_ATTENDANCES PAA
7858: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
7859:
7860: BEGIN
7861:

Line 7980: FROM per_absence_attendances

7976: FUNCTION get_abs_st_date (p_abs_attendance_id IN NUMBER) RETURN DATE IS
7977:
7978: CURSOR csr_get_abs_st_date(p_abs_attn_id IN VARCHAR2 ) IS
7979: SELECT date_start
7980: FROM per_absence_attendances
7981: WHERE absence_attendance_id = p_abs_attn_id ;
7982:
7983: l_abs_st_date DATE ;
7984: