APPS.PSP_SUM_ADJ dependencies on PSP_ADJUSTMENT_CONTROL_TABLE

Line 191: psp_adjustment_control_table pact

187: --- replaced p_run_type with g_run_type for 244657
188: CURSOR pc_batch_cur IS
189: SELECT distinct ppc.batch_name
190: FROM psp_payroll_controls ppc,
191: psp_adjustment_control_table pact
192: WHERE ppc.status_code = decode(g_run_type, 'N', 'N', 'R', 'I')
193: AND ppc.source_type = 'A'
194: AND ppc.batch_name = pact.adjustment_batch_name
195: AND (g_run_type = 'N' OR (g_run_type = 'R' and

Line 4217: delete from psp_adjustment_control_table

4213: delete from psp_payroll_controls
4214: where batch_name = l_batch_name and
4215: source_type = 'A'; --- added this condn 2133056
4216:
4217: delete from psp_adjustment_control_table
4218: where adjustment_batch_name = l_batch_name;
4219:
4220: EXCEPTION
4221: WHEN OTHERS THEN

Line 4438: FROM psp_adjustment_control_table

4434: CURSOR adjustment_control_cur IS
4435: SELECT adjustment_batch_name, person_id, assignment_id, element_type_id,
4436: distribution_start_date, distribution_end_date,
4437: currency_code -- Introduced for bug fix 2916848
4438: FROM psp_adjustment_control_table
4439: WHERE adjustment_batch_name = p_batch_name;
4440:
4441: CURSOR person_name_cur IS
4442: SELECT substr(full_name, 1, 80)