APPS.PN_SPACE_ASSIGN_CUST_PKG dependencies on DUAL

Line 131: FROM DUAL;

127:
128: IF ( X_CUST_SPACE_ASSIGN_ID IS NULL) THEN
129: SELECT pn_space_assign_cust_s.NEXTVAL
130: INTO x_cust_space_assign_id
131: FROM DUAL;
132: END IF;
133:
134: INSERT INTO pn_space_assign_cust_all
135: ( CUST_SPACE_ASSIGN_ID,

Line 582: FROM DUAL;

578: IF X_UPDATE_CORRECT_OPTION = 'UPDATE' THEN
579:
580: SELECT pn_space_assign_cust_s.NEXTVAL
581: INTO l_cust_space_assign_id
582: FROM DUAL;
583:
584: IF X_FIN_OBLIG_END_DATE IS NOT NULL THEN
585: l_fin_oblig_end_date := X_CUST_ASSIGN_START_DATE - 1;
586: ELSE

Line 786: FROM DUAL

782: l_err_flag VARCHAR2(1) := 'N';
783:
784: CURSOR check_cust_assignment IS
785: SELECT 'Y'
786: FROM DUAL
787: WHERE EXISTS (SELECT NULL
788: FROM pn_space_assign_cust_all
789: WHERE cust_account_id = p_cust_acnt_id
790: AND location_id = p_loc_id

Line 866: FROM DUAL

862: l_exists VARCHAR2(1);
863:
864: CURSOR cust_arcl_cur IS
865: SELECT 'Y'
866: FROM DUAL
867: WHERE EXISTS (SELECT NULL
868: FROM pn_rec_arcl_dtlln_all
869: WHERE cust_space_assign_id = p_cust_space_assign_id);
870: BEGIN

Line 1134: SELECT 1 FROM DUAL

1130: WHERE location_id = p_location_id;
1131:
1132: /* S.N. Bug 456550 */
1133: CURSOR office_sec_cur(b_location_id number) IS
1134: SELECT 1 FROM DUAL
1135: WHERE EXISTS
1136: (SELECT '1'
1137: FROM pn_locations_all loc
1138: WHERE loc.location_type_lookup_code in ('OFFICE','SECTION')