APPS.PA_RBS_ASGMT_PVT dependencies on DUAL

Line 32: FROM dual

28: BEGIN
29: BEGIN
30: SELECT 'Y'
31: INTO l_primary_rep_exists
32: FROM dual
33: WHERE EXISTS
34: (SELECT rbs_prj_assignment_id
35: FROM pa_rbs_prj_assignments
36: WHERE project_id = p_project_id

Line 274: FROM dual

270: ************************************************/
271: BEGIN
272: SELECT 'Y'
273: INTO l_exists_association
274: FROM dual
275: WHERE EXISTS
276: (SELECT rbs_prj_assignment_id
277: FROM pa_rbs_prj_assignments
278: WHERE rbs_header_id = p_rbs_header_id

Line 340: FROM DUAL;

336: * PA_RBS_PRJ_ASSIGNMENTS_S
337: ******************************************/
338: SELECT PA_RBS_PRJ_ASSIGNMENTS_S.NEXTVAL
339: INTO l_rbs_prj_assignment_id
340: FROM DUAL;
341: /************************************************
342: * Call to PA_RBS_ASGMT_PKG.Insert_Row procedure, which would
343: * take care of Insertion into the pa_rbs_prj_assignments
344: * table.

Line 706: FROM dual

702: ************************************************/
703: BEGIN
704: SELECT 'Y'
705: INTO l_exists_association
706: FROM dual
707: WHERE EXISTS
708: (SELECT rbs_prj_assignment_id
709: FROM pa_rbs_prj_assignments
710: WHERE rbs_header_id = p_rbs_header_id

Line 772: FROM DUAL;

768: * PA_RBS_PRJ_ASSIGNMENTS_S
769: ******************************************/
770: SELECT PA_RBS_PRJ_ASSIGNMENTS_S.NEXTVAL
771: INTO l_rbs_prj_assignment_id
772: FROM DUAL;
773:
774: PA_RBS_ASGMT_PKG.Insert_Row(
775: p_rbs_assignment_id => l_rbs_prj_assignment_id,
776: p_rbs_header_id => p_rbs_header_id,