APPS.PAY_AU_FOREIGN_WORKERS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 55: (c_status_name per_assignment_status_types.user_status%TYPE)

51:
52: PROCEDURE populate_asg_status_id
53: AS
54: CURSOR get_assignment_status_id
55: (c_status_name per_assignment_status_types.user_status%TYPE)
56: IS
57: SELECT past.assignment_status_type_id
58: FROM per_assignment_status_types past
59: WHERE past.user_status = c_status_name

Line 58: FROM per_assignment_status_types past

54: CURSOR get_assignment_status_id
55: (c_status_name per_assignment_status_types.user_status%TYPE)
56: IS
57: SELECT past.assignment_status_type_id
58: FROM per_assignment_status_types past
59: WHERE past.user_status = c_status_name
60: AND past.legislation_code = 'AU';
61:
62:

Line 154: l_status_id per_assignment_status_types.assignment_status_type_id%TYPE;

150: FUNCTION get_asg_status_id(p_fw_type IN VARCHAR2)
151: RETURN NUMBER
152: IS
153: l_proc_name VARCHAR2(100);
154: l_status_id per_assignment_status_types.assignment_status_type_id%TYPE;
155: BEGIN
156:
157: g_debug := hr_utility.debug_enabled;
158:

Line 238: l_status_id per_assignment_status_types.assignment_status_type_id%TYPE;

234: AND paf.effective_end_date >= c_start_date
235: );
236:
237: l_return_value VARCHAR2(10);
238: l_status_id per_assignment_status_types.assignment_status_type_id%TYPE;
239:
240: l_proc_name VARCHAR2(100);
241:
242: BEGIN

Line 409: l_status_id per_assignment_status_types.assignment_status_type_id%TYPE;

405: AND pps.actual_termination_date BETWEEN c_start_date AND c_end_date
406: AND pps.actual_termination_date BETWEEN paf.effective_start_date and paf.effective_end_date
407: AND paf.assignment_status_type_id = c_status_id;
408:
409: l_status_id per_assignment_status_types.assignment_status_type_id%TYPE;
410: l_return_value VARCHAR2(10);
411: l_actual_term_date DATE;
412: l_proc_name VARCHAR2(100);
413:

Line 520: l_status_id per_assignment_status_types.assignment_status_type_id%TYPE;

516: l_proc_name VARCHAR2(100);
517:
518: l_term_emp VARCHAR2(10);
519: l_act_term_date DATE;
520: l_status_id per_assignment_status_types.assignment_status_type_id%TYPE;
521:
522: BEGIN
523:
524: g_debug := hr_utility.debug_enabled;

Line 874: ,c_status_id per_assignment_status_types.assignment_status_type_id%TYPE

870: AND hsc.segment1 = c_tax_unit_id
871: );
872:
873: CURSOR get_fw_days(c_assignment_id per_assignments_f.assignment_id%TYPE
874: ,c_status_id per_assignment_status_types.assignment_status_type_id%TYPE
875: ,c_payroll_id per_time_periods.payroll_id%TYPE
876: ,c_time_period_id per_time_periods.time_period_id%TYPE)
877: IS
878: SELECT ptp.time_period_id

Line 892: l_status_id per_assignment_status_types.assignment_status_type_id%TYPE;

888: AND ptp.end_date >= paf.effective_start_date;
889:
890:
891: l_procedure VARCHAR2(100);
892: l_status_id per_assignment_status_types.assignment_status_type_id%TYPE;
893:
894: l_le_exists VARCHAR2(10);
895: l_return_value NUMBER;
896: