APPS.PAY_ZA_TAX_REG_AR dependencies on PER_ALL_ASSIGNMENTS_F

Line 33: g_spc_asg_id per_all_assignments_f.assignment_id%TYPE;

29: g_end_period_id per_time_periods.time_period_id%type;
30: g_payroll_name pay_payrolls_f.payroll_name%type := null;
31: g_end_period_date per_time_periods.end_date%type;
32: g_inc_all_asg VARCHAR2(1);
33: g_spc_asg_id per_all_assignments_f.assignment_id%TYPE;
34: g_ret_ptd VARCHAR2(1);
35: g_ret_mtd VARCHAR2(1);
36: g_ret_ytd VARCHAR2(1);
37: g_sort1 VARCHAR2(100);

Line 152: , p_asg_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL

148: -- TODO Tune this cursor so as to retrive only required onfo
149: CURSOR csr_processed_assignments (
150: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE DEFAULT NULL
151: , p_period_end_date IN per_time_periods.end_date%TYPE
152: , p_asg_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
153: , p_legal_entity_id NUMBER
154: )
155: IS
156: SELECT PAF.assignment_id

Line 378: and PAF.effective_start_date = (select max(effective_start_date) from per_all_assignments_f paf2

374: where paa.assignment_action_id = p_assactid
375: and PAF.assignment_id = paa.assignment_id
376: and ptp.payroll_id = PAF.payroll_id
377: -- and g_end_period_date between PAF.effective_start_date and PAF.effective_end_date
378: and PAF.effective_start_date = (select max(effective_start_date) from per_all_assignments_f paf2
379: where paf2.assignment_id = paa.assignment_id
380: and effective_start_date <= g_end_period_date)
381: and g_end_period_date between ptp.start_date and ptp.end_date;
382: