DBA Data[Home] [Help]

APPS.HXT_TIME_GEN dependencies on HR_GENERAL

Line 602: hr_general.end_of_time

598: - 1),
599: c_end
600: )
601: ),
602: hr_general.end_of_time
603: ) end_date
604: FROM hxt_rotation_schedules rt1, hxt_rotation_schedules rt2
605: WHERE rt1.rtp_id = rt2.rtp_id(+)
606: AND rt2.start_date(+) > rt1.start_date

Line 612: - 1, hr_general.end_of_time)

608: AND c_end >= rt1.start_date
609: GROUP BY rt1.tws_id, rt1.start_date
610: HAVING c_start <=
611: NVL ( MIN (rt2.start_date)
612: - 1, hr_general.end_of_time)
613: ORDER BY rt1.start_date;
614:
615: l_cntr NUMBER := 1;
616: BEGIN

Line 796: hr_general.end_of_time);

792: VALUES (l_tim_id, g_asm_rec.person_id, g_payroll_id,
793: g_time_period_id, a_batch_id, 'A', g_user_id,
794: g_sysdatetime, g_user_id, g_sysdatetime,
795: g_login_id, g_sysdate,
796: hr_general.end_of_time);
797:
798: RETURN (l_tim_id);
799: EXCEPTION
800: WHEN OTHERS

Line 953: g_sysdate, hr_general.end_of_time, g_asm_rec.egp_id);

949: -- , g_user_id
950: -- , g_sysdatetime
951: -- , g_login_id
952: ,
953: g_sysdate, hr_general.end_of_time, g_asm_rec.egp_id);
954:
955: -- , l_group_id);
956: COMMIT;
957:

Line 1044: hr_general.end_of_time,

1040: a_start -- START DATE SPR C389
1041: ,
1042: l_rowid,
1043: g_sysdate,
1044: hr_general.end_of_time,
1045: NULL -- PROJACCT Project_id
1046: ,
1047: NULL -- TA35 Job_id
1048: ,

Line 1158: hr_general.end_of_time,

1154: a_error_text,
1155: g_err_loc,
1156: a_ora_err_text,
1157: g_sysdate,
1158: hr_general.end_of_time,
1159: 'ERR'
1160: );
1161: -- Set error flag
1162: g_errors := TRUE;