APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on OTA_PERSON_ACTIONS_S

Line 749: Cursor C_Sel1 is select OTA_PERSON_ACTIONS_S.nextval from sys.dual;

745: l_proc varchar2(72) := g_package||'create_request_member_record';
746:
747: l_person_action_id OTA_MAND_MULTI_ENR_REQ_MEMBERS.PERSON_ACTION_ID%type := NULL;
748:
749: Cursor C_Sel1 is select OTA_PERSON_ACTIONS_S.nextval from sys.dual;
750:
751: BEGIN
752:
753: hr_utility.set_location(' Entering:'||l_proc, 5);

Line 3057: Cursor C_Sel1 is select OTA_PERSON_ACTIONS_S.nextval from sys.dual;

3053: l_proc varchar2(72) := g_package||'create_cert_req_member_record';
3054:
3055: l_person_action_id OTA_MAND_MULTI_ENR_REQ_MEMBERS.PERSON_ACTION_ID%type := NULL;
3056:
3057: Cursor C_Sel1 is select OTA_PERSON_ACTIONS_S.nextval from sys.dual;
3058:
3059: BEGIN
3060:
3061: hr_utility.set_location(' Entering:'||l_proc, 5);