1045: and ast.pay_system_status = 'P'; -- Check payroll status
1046:
1047: BEGIN
1048: IF p_batch_ref IS NULL THEN
1049: hxt_user_exits.Define_Reference_Number(i_payroll_id,
1050: i_time_period_id,
1051: i_assignment_id,
1052: i_person_id,
1053: l_user_name,
1089:
1090: -- from the batch id, get the batch name
1091: IF p_batch_name IS NULL
1092: THEN
1093: hxt_user_exits.define_batch_name (
1094: l_batch_id,
1095: l_batch_name,
1096: l_error_text
1097: );
1101: RETURN 2;
1102: END IF;
1103: --
1104: IF p_batch_name IS NULL THEN
1105: hxt_user_exits.Define_Batch_Name(l_batch_id, l_batch_name, l_error_text);*/
1106: ELSE
1107: l_batch_name := p_batch_name || 'R' || to_char(l_batch_id);
1108: END IF;
1109: