APPS.PSP_ER_WORKFLOW dependencies on PSP_SELECTED_PERSONS_T

Line 125: /* Following statement added to purge psp_selected_persons_t in dinit code, when run is successful * /

121: p_return_status => l_return_status);
122: END IF;
123:
124: -- Moved teh deletion of temporary table to submit and Purge code paths.
125: /* Following statement added to purge psp_selected_persons_t in dinit code, when run is successful * /
126: DELETE from psp_selected_persons_t WHERE request_id=l_request_id and not exists
127: (select 1 from pay_payroll_actions where payroll_action_id =pactid and action_status
128: ='E') ;
129: -- End of comment *****/

Line 126: DELETE from psp_selected_persons_t WHERE request_id=l_request_id and not exists

122: END IF;
123:
124: -- Moved teh deletion of temporary table to submit and Purge code paths.
125: /* Following statement added to purge psp_selected_persons_t in dinit code, when run is successful * /
126: DELETE from psp_selected_persons_t WHERE request_id=l_request_id and not exists
127: (select 1 from pay_payroll_actions where payroll_action_id =pactid and action_status
128: ='E') ;
129: -- End of comment *****/
130:

Line 171: -- Following statement added to purge psp_selected_persons_t in dinit code, when run is successful

167: where request_id = l_request_id;
168: end if;
169: close check_pre_approved_cur;
170:
171: -- Following statement added to purge psp_selected_persons_t in dinit code, when run is successful
172: DELETE FROM psp_selected_persons_t
173: WHERE request_id=l_request_id;
174: exception
175: when others then

Line 172: DELETE FROM psp_selected_persons_t

168: end if;
169: close check_pre_approved_cur;
170:
171: -- Following statement added to purge psp_selected_persons_t in dinit code, when run is successful
172: DELETE FROM psp_selected_persons_t
173: WHERE request_id=l_request_id;
174: exception
175: when others then
176: -- populate stack with error message

Line 498: -- Following statement added to purge psp_selected_persons_t in dinit code, when run is successful

494: WHERE per.request_id = l_request_id)))
495: AND fdl.document_id = fad.document_id
496: AND fad.entity_name = 'ERDETAILS');
497:
498: -- Following statement added to purge psp_selected_persons_t in dinit code, when run is successful
499: DELETE FROM psp_selected_persons_t
500: WHERE request_id=l_request_id;
501:
502: result := 'COMPLETE';

Line 499: DELETE FROM psp_selected_persons_t

495: AND fdl.document_id = fad.document_id
496: AND fad.entity_name = 'ERDETAILS');
497:
498: -- Following statement added to purge psp_selected_persons_t in dinit code, when run is successful
499: DELETE FROM psp_selected_persons_t
500: WHERE request_id=l_request_id;
501:
502: result := 'COMPLETE';
503: end if;

Line 1795: FROM psp_selected_persons_t

1791: l_emp_matching_selection NUMBER;
1792:
1793: CURSOR emp_matching_selection_cur IS
1794: SELECT COUNT(DISTINCT person_id) -- Modified count(*) to count(distinct person_id) for bug fix 4429787
1795: FROM psp_selected_persons_t
1796: WHERE request_id = p_request_id;
1797: begin
1798:
1799: l_user_name := fnd_global.user_name;