DBA Data[Home] [Help]

APPS.PAY_SE_WORK_TIME_CERTIFICATE dependencies on HR_LOC_WORK_SCHEDULE

Line 1003: hr_loc_work_schedule.calc_sch_based_dur (g_assignment_id

999: -- *****************************************************************************
1000: -- FIND FOR THE WHOLE MONTH in DAYS
1001: -- *****************************************************************************
1002: l_return :=
1003: hr_loc_work_schedule.calc_sch_based_dur (g_assignment_id
1004: ,'D'
1005: ,'Y'
1006: ,l_month_start
1007: ,l_month_end

Line 1027: hr_loc_work_schedule.calc_sch_based_dur (g_assignment_id

1023: LOOP
1024: --logger ('lr_abs.STARTDATE ', lr_abs.startdate);
1025: --logger ('lr_abs.ENDDATE ', lr_abs.enddate);
1026: l_return :=
1027: hr_loc_work_schedule.calc_sch_based_dur (g_assignment_id
1028: ,'D'
1029: ,'Y'
1030: ,lr_abs.startdate
1031: ,lr_abs.enddate

Line 1048: hr_loc_work_schedule.calc_sch_based_dur (g_assignment_id

1044: -- DAYS OVER
1045: -- FIND FOR WHOLE MONTH IN HOURS
1046: -- *****************************************************************************
1047: l_return :=
1048: hr_loc_work_schedule.calc_sch_based_dur (g_assignment_id
1049: ,'H'
1050: ,'Y'
1051: ,l_month_start
1052: ,l_month_end

Line 1072: hr_loc_work_schedule.calc_sch_based_dur (g_assignment_id

1068: LOOP
1069: --logger ('lr_abs.STARTDATE ', lr_abs.startdate);
1070: --logger ('lr_abs.ENDDATE ', lr_abs.enddate);
1071: l_return :=
1072: hr_loc_work_schedule.calc_sch_based_dur (g_assignment_id
1073: ,'H'
1074: ,'Y'
1075: ,lr_abs.startdate
1076: ,lr_abs.enddate

Line 1501: hr_loc_work_schedule.calc_sch_based_dur

1497: -- *****************************************************************************
1498: -- FIND FOR WHOLE MONTH IN HOURS
1499: -- *****************************************************************************
1500: l_return :=
1501: hr_loc_work_schedule.calc_sch_based_dur
1502: (g_assignment_id
1503: ,'H'
1504: ,'Y'
1505: ,l_curr_month_start

Line 1527: hr_loc_work_schedule.calc_sch_based_dur

1523: LOOP
1524: --logger ('lr_abs.STARTDATE ', lr_abs.startdate);
1525: --logger ('lr_abs.ENDDATE ', lr_abs.enddate);
1526: l_return :=
1527: hr_loc_work_schedule.calc_sch_based_dur
1528: (g_assignment_id
1529: ,'H'
1530: ,'Y'
1531: ,lr_abs.startdate