DBA Data[Home] [Help]

APPS.PQH_ASG_WRAPPER dependencies on PER_ASSIGNMENTS_F

Line 1148: per_assignments_f.assignment_number%TYPE) IS

1144: -- |------------------------------< WRITE_HEADER >----------------------------+
1145: -- ---------------------------------------------------------------------------+
1146: --
1147: PROCEDURE Write_Header(p_assignment_number IN
1148: per_assignments_f.assignment_number%TYPE) IS
1149: --
1150: l_proc varchar2(72) := g_package||'Write_Header';
1151: --
1152: BEGIN

Line 1170: p_assignment_number IN per_assignments_f.assignment_number%TYPE,

1166: -- |-------------------------------< LOG_ERROR >------------------------------+
1167: -- ---------------------------------------------------------------------------+
1168: --
1169: PROCEDURE Log_Error(p_type IN VARCHAR2,
1170: p_assignment_number IN per_assignments_f.assignment_number%TYPE,
1171: p_warning_message IN VARCHAR2,
1172: p_already_errored IN OUT NOCOPY BOOLEAN) IS
1173: --
1174: v_error_message VARCHAR2(255) := NULL;

Line 3474: FROM per_assignments_f paf

3470: l_tax_district_changed_warning BOOLEAN;
3471: --
3472: CURSOR csr_assignment_type IS
3473: SELECT assignment_type
3474: FROM per_assignments_f paf
3475: WHERE paf.assignment_id = p_assignment_id
3476: AND l_effective_date BETWEEN paf.effective_start_Date
3477: AND paf.effective_end_date;
3478: --