APPS.PSP_SUM_ADJ dependencies on PSP_ADJUSTMENT_CONTROL_TABLE

Line 251: psp_adjustment_control_table pact

247: --- replaced p_run_type with g_run_type for 244657
248: CURSOR pc_batch_cur IS
249: SELECT distinct ppc.batch_name
250: FROM psp_payroll_controls ppc,
251: psp_adjustment_control_table pact
252: WHERE ppc.status_code = decode(g_run_type, 'N', 'N', 'R', 'I')
253: AND ppc.source_type = 'A'
254: AND ppc.batch_name = pact.adjustment_batch_name
255: AND (g_run_type = 'N' OR (g_run_type = 'R' and

Line 4648: delete from psp_adjustment_control_table

4644: delete from psp_payroll_controls
4645: where batch_name = l_batch_name and
4646: source_type = 'A'; --- added this condn 2133056
4647:
4648: delete from psp_adjustment_control_table
4649: where adjustment_batch_name = l_batch_name;
4650:
4651: EXCEPTION
4652: WHEN OTHERS THEN

Line 4869: FROM psp_adjustment_control_table

4865: CURSOR adjustment_control_cur IS
4866: SELECT adjustment_batch_name, person_id, assignment_id, element_type_id,
4867: distribution_start_date, distribution_end_date,
4868: currency_code -- Introduced for bug fix 2916848
4869: FROM psp_adjustment_control_table
4870: WHERE adjustment_batch_name = p_batch_name;
4871:
4872: CURSOR person_name_cur IS
4873: SELECT substr(full_name, 1, 80)