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 2991: FROM dual;

2987: --managers in the end when there are no pending approvals
2988: ---------------------------------------------------------------------
2989: SELECT PA_WF_NTF_PERFORMERS_S.nextval
2990: INTO l_group_id
2991: FROM dual;
2992:
2993: OPEN get_submitter_details;
2994: FETCH get_submitter_details INTO l_submitter_rec;
2995: CLOSE get_submitter_details;

Line 3555: FROM dual;

3551: FOR rec IN distinct_approvers LOOP
3552:
3553: SELECT PA_WF_NTF_PERFORMERS_S.nextval
3554: INTO l_approver_group_id
3555: FROM dual;
3556:
3557: UPDATE pa_wf_ntf_performers
3558: SET approver_group_id = l_approver_group_id
3559: WHERE group_id = l_group_id

Line 3909: FROM dual;

3905: -- Create the unique item key to launch WF with
3906: -----------------------------------------------
3907: SELECT pa_prm_wf_item_key_s.nextval
3908: INTO l_itemkey
3909: FROM dual;
3910:
3911: l_wf_started_by_id := FND_GLOBAL.user_id;
3912: l_responsibility_id := FND_GLOBAL.resp_id;
3913: l_resp_appl_id := FND_GLOBAL.resp_appl_id;