APPS.PSP_ENC_ASSIGNMENT_CHANGES dependencies on PSP_ENC_SUMMARY_LINES

Line 48: FROM psp_enc_summary_lines

44:
45: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table START
46: CURSOR check_enc_run_csr(p_payroll_id NUMBER) IS
47: SELECT 'Y'
48: FROM psp_enc_summary_lines
49: WHERE payroll_id = p_payroll_id
50: AND assignment_id = p_assignment_id
51: AND status_code IN ('A', 'N')
52: AND ROWNUM = 1;

Line 126: FROM psp_enc_summary_lines

122:
123: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table START
124: CURSOR check_enc_run_csr(p_payroll_id NUMBER) IS
125: SELECT 'Y'
126: FROM psp_enc_summary_lines
127: WHERE payroll_id = p_payroll_id
128: AND assignment_id = p_assignment_id_o
129: AND status_code IN ('A', 'N')
130: AND ROWNUM = 1;

Line 201: FROM psp_enc_summary_lines

197:
198: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table START
199: CURSOR check_enc_run_csr(p_payroll_id NUMBER) IS
200: SELECT 'Y'
201: FROM psp_enc_summary_lines
202: WHERE payroll_id = p_payroll_id
203: AND assignment_id = p_assignment_id_o
204: AND status_code IN ('A', 'N')
205: AND ROWNUM = 1;

Line 294: FROM psp_enc_summary_lines

290: */
291:
292: CURSOR check_enc_run_csr(p_payroll_id NUMBER) IS
293: SELECT 'Y'
294: FROM psp_enc_summary_lines
295: WHERE payroll_id = p_payroll_id
296: AND assignment_id = p_new_assignment_id
297: AND status_code IN ('A', 'N')
298: AND ROWNUM = 1;

Line 418: from psp_enc_summary_lines

414: THEN
415:
416: select count(*)
417: into l_count1
418: from psp_enc_summary_lines
419: where status_code = 'A'
420: and person_id = p_new_person_id
421: and award_id is not null
422: and effective_date > p_new_effective_end_date; --- added date check for 3413373

Line 430: from psp_enc_summary_lines

426:
427:
428: select count(*)
429: into l_count2
430: from psp_enc_summary_lines
431: where status_code = 'N'
432: and person_id = p_new_person_id
433: and award_id is not null
434: and effective_date > p_new_effective_end_date; --bug 5977888

Line 497: from psp_enc_summary_lines

493: IF (p_actual_date IS NOT NULL ) THEN
494:
495: select count(*)
496: into l_count1
497: from psp_enc_summary_lines
498: where status_code = 'A'
499: and person_id = p_new_person_id
500: and award_id is not null
501: and effective_date > p_new_effective_end_date; --- added date check for 3413373

Line 508: from psp_enc_summary_lines

504: hr_utility.trace ('LD3 STATUS : A l_count1 = '||l_count1);
505:
506: select count(*)
507: into l_count2
508: from psp_enc_summary_lines
509: where status_code = 'N'
510: and person_id = p_new_person_id
511: and award_id is not null
512: and effective_date > p_new_effective_end_date; --bug 5977888

Line 601: FROM psp_enc_summary_lines

597: IS
598: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table START
599: CURSOR check_enc_run_csr(p_payroll_id NUMBER) IS
600: SELECT 'Y'
601: FROM psp_enc_summary_lines
602: WHERE payroll_id = p_payroll_id
603: AND assignment_id = p_old_assignment_id
604: AND status_code IN ('A', 'N')
605: AND ROWNUM = 1;

Line 693: from psp_enc_summary_lines

689: then
690:
691: select count(*)
692: into l_count1
693: from psp_enc_summary_lines
694: where status_code = 'A'
695: and person_id = p_old_person_id
696: and award_id is not null
697: and effective_date > p_old_effective_start_date;

Line 709: from psp_enc_summary_lines

705: END IF;
706:
707: select count(*)
708: into l_count2
709: from psp_enc_summary_lines
710: where status_code = 'N'
711: AND person_id = p_old_person_id
712: and award_id is not null
713: and effective_date > p_old_effective_start_date;

Line 757: FROM psp_enc_summary_lines

753: and effective_start_date <= p_old_effective_end_date ;
754:
755: CURSOR check_enc_run_csr(p_payroll_id NUMBER) IS
756: SELECT 'Y'
757: FROM psp_enc_summary_lines
758: WHERE payroll_id = p_payroll_id
759: AND assignment_id = p_assignment_id
760: AND status_code IN ('A', 'N')
761: AND ROWNUM = 1;