APPS.PSP_ENC_CREATE_LINES dependencies on PSP_ENC_CHANGED_ASG_HISTORY

Line 7891: INSERT INTO psp_enc_changed_asg_history

7887: WHERE peca2.assignment_id = peca.assignment_id
7888: AND peca2.change_type = 'TR');
7889: END IF;
7890:
7891: INSERT INTO psp_enc_changed_asg_history
7892: (request_id, assignment_id, payroll_id, change_type, processing_module, created_by,
7893: creation_date, processed_flag, reference_id, action_type, payroll_action_id, change_date)
7894: SELECT l_request_id, peca.assignment_id, peca.payroll_id, peca.change_type,
7895: 'U', l_last_updated_by, l_last_update_date, NULL, NVL(peca.reference_id, 0),

Line 7899: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_asg_history');

7895: 'U', l_last_updated_by, l_last_update_date, NULL, NVL(peca.reference_id, 0),
7896: NVL(peca.action_type, 'U'), p_payroll_action_id, change_date
7897: FROM psp_enc_changed_assignments peca
7898: WHERE payroll_action_id = p_payroll_action_id;
7899: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_asg_history');
7900:
7901: DELETE psp_enc_changed_assignments peca
7902: WHERE peca.payroll_action_id = p_payroll_action_id;
7903: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted processed change assignment records in psp_enc_change_assignments');

Line 9591: SELECT ASSIGNMENT_ID FROM psp_enc_changed_asg_history

9587: and assignment_id IN(SELECT assignment_id from PSP_ENC_PAYROLL_ASSIGNMENT_V
9588: WHERE payroll_id = p_payroll_id
9589: AND exclude = 'Y'
9590: MINUS
9591: SELECT ASSIGNMENT_ID FROM psp_enc_changed_asg_history
9592: WHERE payroll_id = p_payroll_id);
9593: */
9594: -- Modified the delete statement for bug 9862281
9595: BEGIN

Line 9609: FROM psp_enc_changed_asg_history

9605:
9606: BEGIN
9607: SELECT /*+ FIRST_ROWS(1) */ 1
9608: INTO l_asg_exists
9609: FROM psp_enc_changed_asg_history
9610: WHERE assignment_id = asg_id_tab(rec_i)
9611: AND payroll_id = p_payroll_id
9612: AND ROWNUM < 2;
9613: EXCEPTION

Line 10167: FROM psp_enc_changed_asg_history pecah

10163: (request_id, assignment_id, payroll_id, change_type,
10164: processed_flag, reference_id, action_type, change_date)
10165: SELECT l_request_id, pecah.assignment_id, pecah.payroll_id, pecah.change_type,
10166: NULL, NVL(pecah.reference_id, 0), pecah.action_type, change_date
10167: FROM psp_enc_changed_asg_history pecah
10168: WHERE payroll_action_id = p_payroll_action_id
10169: AND action_type NOT IN ('CR', 'LQ', 'TR');
10170: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
10171:

Line 10172: DELETE psp_enc_changed_asg_history

10168: WHERE payroll_action_id = p_payroll_action_id
10169: AND action_type NOT IN ('CR', 'LQ', 'TR');
10170: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
10171:
10172: DELETE psp_enc_changed_asg_history
10173: WHERE payroll_action_id = p_payroll_action_id;
10174: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
10175: ELSE
10176: OPEN asg_cur(p_person_id1, p_assignment_id1);

Line 10288: FROM psp_enc_changed_asg_history pecah

10284: (request_id, assignment_id, payroll_id, change_type,
10285: processed_flag, reference_id, action_type, change_date)
10286: SELECT l_request_id, pecah.assignment_id, pecah.payroll_id, pecah.change_type,
10287: NULL, NVL(pecah.reference_id, 0), pecah.action_type, change_date
10288: FROM psp_enc_changed_asg_history pecah
10289: WHERE payroll_action_id = p_payroll_action_id
10290: AND assignment_id = l_assignments(recno)
10291: AND action_type NOT IN ('CR', 'LQ', 'TR');
10292: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');

Line 10294: DELETE psp_enc_changed_asg_history

10290: AND assignment_id = l_assignments(recno)
10291: AND action_type NOT IN ('CR', 'LQ', 'TR');
10292: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
10293:
10294: DELETE psp_enc_changed_asg_history
10295: WHERE payroll_action_id = p_payroll_action_id
10296: AND assignment_id = l_assignments(recno);
10297: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
10298: END LOOP;