APPS.PA_ASSIGNMENT_APPROVAL_PUB dependencies on DUAL

Line 1310: FROM DUAL;

1306: l_updated_asmt_rec.expenditure_type_class,
1307: l_updated_asmt_rec.expenditure_type,
1308: l_updated_asmt_rec.location_id,
1309: l_updated_asmt_rec.staffing_owner_person_id
1310: FROM DUAL;
1311: END IF;
1312:
1313: ------------------------------------------------------------------------------
1314: -- Populate Table for the updated assignment items

Line 2930: FROM dual;

2926: --managers in the end when there are no pending approvals
2927: ---------------------------------------------------------------------
2928: SELECT PA_WF_NTF_PERFORMERS_S.nextval
2929: INTO l_group_id
2930: FROM dual;
2931:
2932: OPEN get_submitter_details;
2933: FETCH get_submitter_details INTO l_submitter_rec;
2934: CLOSE get_submitter_details;

Line 3490: FROM dual;

3486: FOR rec IN distinct_approvers LOOP
3487:
3488: SELECT PA_WF_NTF_PERFORMERS_S.nextval
3489: INTO l_approver_group_id
3490: FROM dual;
3491:
3492: UPDATE pa_wf_ntf_performers
3493: SET approver_group_id = l_approver_group_id
3494: WHERE group_id = l_group_id

Line 3844: FROM dual;

3840: -- Create the unique item key to launch WF with
3841: -----------------------------------------------
3842: SELECT pa_prm_wf_item_key_s.nextval
3843: INTO l_itemkey
3844: FROM dual;
3845:
3846: l_wf_started_by_id := FND_GLOBAL.user_id;
3847: l_responsibility_id := FND_GLOBAL.resp_id;
3848: l_resp_appl_id := FND_GLOBAL.resp_appl_id;