APPS.PSP_ENC_ASSIGNMENT_CHANGES dependencies on PER_ALL_ASSIGNMENTS_F

Line 37: FROM per_all_assignments_f

33: AND ROWNUM = 1;
34:
35: CURSOR PAYROLL_ID_CUR IS
36: SELECT PAYROLL_ID
37: FROM per_all_assignments_f
38: WHERE assignment_id = p_assignment_id
39: --AND SYSDATE BETWEEN effective_start_date AND effective_end_date; Commented For Bug 3451760
40: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
41:

Line 118: FROM per_all_assignments_f

114: AND ROWNUM = 1;
115:
116: CURSOR payroll_id_cur IS
117: SELECT payroll_id
118: FROM per_all_assignments_f
119: WHERE assignment_id = p_assignment_id_o
120: --AND SYSDATE BETWEEN effective_start_date AND effective_end_date; Commented for Bug 3451760
121: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
122:

Line 194: FROM per_all_assignments_f

190: AND ROWNUM = 1;
191:
192: CURSOR PAYROLL_ID_CUR IS
193: SELECT payroll_id
194: FROM per_all_assignments_f
195: WHERE assignment_id = p_assignment_id_o
196: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
197:
198: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table START

Line 355: record in per_all_assignments_f results in both in an INSERT as well as UPDATE operation */

351:
352: /* Check if Old and new payroll_id's are NULL, and there is no change in Organization or
353: assignment_status,theb do not insert. If old and new payroll values are different or if the
354: organization or assignment_status is different insert a record. Any update of a date tracked
355: record in per_all_assignments_f results in both in an INSERT as well as UPDATE operation */
356:
357: /* Commented the following code and Break the If condition into if elsif conditions
358:
359: IF (NVL(p_old_payroll_id,0) <> NVL(p_new_payroll_id,0) OR

Line 750: from per_all_assignments_f

746: IS
747:
748: Cursor get_asg_payroll IS
749: select payroll_id
750: from per_all_assignments_f
751: where assignment_id = p_assignment_id
752: and effective_end_date >= p_new_effective_start_date
753: and effective_start_date <= p_old_effective_end_date ;
754: