APPS.AHL_FMP_MR_RELATION_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 19

SELECT lookup_code
   FROM FND_LOOKUP_VALUES_VL
   WHERE lookup_code = c_lookup_code
   AND lookup_type = c_lookup_type
   AND sysdate between nvl(start_date_active,sysdate)
   AND nvl(end_date_active,sysdate);

Line: 167

  SELECT MR_HEADER_ID
  FROM AHL_MR_HEADERS_APP_V A
  WHERE UPPER(TITLE)=(C_TITLE)
  AND  MR_STATUS_CODE<>'TERMINATED'
  AND trunc(NVL(EFFECTIVE_TO,SYSDATE+1))>SYSDATE
  AND NVL(TYPE_CODE,'X')=DECODE(C_TYPE_CODE,'ACTIVITY','PROGRAM', 'PROGRAM','ACTIVITY','X');

Line: 176

  SELECT TITLE
  FROM AHL_MR_HEADERS_APP_V
  WHERE MR_HEADER_ID=C_MR_HEADER_ID
  AND  MR_STATUS_CODE<>'TERMINATED'
  AND trunc(NVL(EFFECTIVE_TO,SYSDATE+1))>SYSDATE
  AND NVL(TYPE_CODE,'X')=DECODE(NVL(C_TYPE_CODE,'X'),'ACTIVITY','PROGRAM','PROGRAM','ACTIVITY','X');

Line: 199

                SELECT TYPE_CODE INTO L_TYPE_CODE
                FROM AHL_MR_HEADERS_B
                WHERE MR_HEADER_ID=p_x_mr_relation_rec.MR_HEADER_ID;

Line: 231

                                    SELECT TITLE INTO l_title
                                    FROM AHL_MR_HEADERS_B
                                    WHERE MR_HEADER_ID=p_x_mr_relation_rec.MR_HEADER_ID;

Line: 270

        SELECT COUNT(*) INTO l_counter
        FROM   AHL_MR_RELATIONSHIPS
        WHERE  RELATIONSHIP_CODE = P_RELATIONSHIP_CODE -- pdoki added for SBE Project
        START WITH RELATED_MR_HEADER_ID=P_RELATED_MR_HEADER_ID
        CONNECT BY PRIOR  RELATED_MR_HEADER_ID=MR_HEADER_ID;

Line: 313

  SELECT MR_STATUS_CODE,TITLE,TYPE_CODE
  FROM AHL_MR_HEADERS_B
  WHERE MR_HEADER_ID=C_MR_HEADER_ID;

Line: 325

  select *
  from  AHL_MR_RELATIONSHIPS
  where MR_HEADER_ID=C_MR_HEADER_ID
  and   RELATED_MR_HEADER_ID=C_RELATED_MR_HEADER_ID
  and   relationship_code=c_relationship_code;

Line: 334

  select *
  FROM  AHL_MR_RELATIONSHIPS
  WHERE RELATIONSHIP_CODE NOT IN (C_RELATIONSHIP_CODE, 'PARENT')
  AND ((MR_HEADER_ID=C_MR_HEADER_ID  AND   RELATED_MR_HEADER_ID=C_RELATED_MR_HEADER_ID)
  OR (MR_HEADER_ID = C_RELATED_MR_HEADER_ID AND RELATED_MR_HEADER_ID = C_MR_HEADER_ID));

Line: 343

  SELECT TITLE
  FROM   AHL_MR_HEADERS_B
  WHERE  MR_HEADER_ID=C_RELATED_MR_HEADER_ID
  AND    IMPLEMENT_STATUS_CODE = 'OPTIONAL_DO_NOT_IMPLEMENT';

Line: 351

  select *
  from  AHL_MR_RELATIONSHIPS
  where relationship_code = 'PARENT'
  and  (MR_HEADER_ID=C_RELATED_MR_HEADER_ID or RELATED_MR_HEADER_ID=C_RELATED_MR_HEADER_ID);

Line: 360

  select *
  from  AHL_MR_RELATIONSHIPS
  where relationship_code = 'TERMINATES'
  and  (MR_HEADER_ID=C_RELATED_MR_HEADER_ID or RELATED_MR_HEADER_ID=C_RELATED_MR_HEADER_ID);

Line: 369

  select 'x'
  from   AHL_MR_LOOP_CHAIN_RELNS
  where  MR_HEADER_ID= c_related_mr_header_id
  and    MR_RELATIONSHIP_ID = START_MR_RELATIONSHIP_ID
  and    relationship_code = 'CHAIN';

Line: 387

    SELECT  'x'
    FROM    ahl_mr_headers_b
    WHERE   mr_header_id = c_mr_header_id AND
            program_type_code = 'MO_PROC';

Line: 398

    SELECT implement_status_code, title, version_number
    FROM ahl_mr_headers_b
    WHERE mr_header_id = c_mr_header_id;

Line: 550

                                  select TITLE into l_mr_title from AHL_MR_HEADERS_B where mr_header_id = p_mr_relation_rec.mr_header_id;

Line: 581

                                 select title into l_mr_title from AHL_MR_HEADERS_B where MR_HEADER_ID = P_MR_RELATION_REC.mr_header_id;

Line: 698

                    select title into l_mr_title from AHL_MR_HEADERS_B where MR_HEADER_ID = P_MR_RELATION_REC.mr_header_id;

Line: 782

                         select title into l_mr_title from AHL_MR_HEADERS_B where MR_HEADER_ID = P_MR_RELATION_REC.mr_header_id;

Line: 1015

                delete AHL_MR_RELATIONSHIPS
                where MR_RELATIONSHIP_ID = p_x_mr_relation_tbl(i).MR_RELATIONSHIP_ID
                and  OBJECT_VERSION_NUMBER=p_x_mr_relation_tbl(i).OBJECT_VERSION_NUMBER;

Line: 1030

                update AHL_mr_RELATIONSHIPS
                  set MR_HEADER_ID = p_x_mr_relation_tbl(i).MR_HEADER_ID,
                    RELATED_MR_HEADER_ID        = p_x_mr_relation_tbl(i).RELATED_MR_HEADER_ID,
                    RELATIONSHIP_CODE           = p_x_mr_relation_tbl(i).RELATIONSHIP_CODE,
                    MR_RELATIONSHIP_ID          = p_x_mr_relation_tbl(i).MR_RELATIONSHIP_ID,
                    OBJECT_VERSION_NUMBER       = p_x_mr_relation_tbl(i).OBJECT_VERSION_NUMBER + 1,
                    ATTRIBUTE_CATEGORY          = p_x_mr_relation_tbl(i).ATTRIBUTE_CATEGORY,
                    ATTRIBUTE1                  = p_x_mr_relation_tbl(i).ATTRIBUTE1,
                    ATTRIBUTE2                  = p_x_mr_relation_tbl(i).ATTRIBUTE2,
                    ATTRIBUTE3                  = p_x_mr_relation_tbl(i).ATTRIBUTE3,
                    ATTRIBUTE4                  = p_x_mr_relation_tbl(i).ATTRIBUTE4,
                    ATTRIBUTE5                  = p_x_mr_relation_tbl(i).ATTRIBUTE5,
                    ATTRIBUTE6                  = p_x_mr_relation_tbl(i).ATTRIBUTE6,
                    ATTRIBUTE7                  = p_x_mr_relation_tbl(i).ATTRIBUTE7,
                    ATTRIBUTE8                  = p_x_mr_relation_tbl(i).ATTRIBUTE8,
                    ATTRIBUTE9                  = p_x_mr_relation_tbl(i).ATTRIBUTE9,
                    ATTRIBUTE10                 = p_x_mr_relation_tbl(i).ATTRIBUTE10,
                    ATTRIBUTE11                 = p_x_mr_relation_tbl(i).ATTRIBUTE11,
                    ATTRIBUTE12                 = p_x_mr_relation_tbl(i).ATTRIBUTE12,
                    ATTRIBUTE13                 = p_x_mr_relation_tbl(i).ATTRIBUTE13,
                    ATTRIBUTE14                 = p_x_mr_relation_tbl(i).ATTRIBUTE14,
                    ATTRIBUTE15                 = p_x_mr_relation_tbl(i).ATTRIBUTE15,
                    LAST_UPDATE_DATE            = sysdate,
                    LAST_UPDATED_BY             = fnd_global.user_id,
                    LAST_UPDATE_LOGIN           = fnd_global.user_id
                 where MR_RELATIONSHIP_ID       = p_x_mr_relation_tbl(i).MR_RELATIONSHIP_ID
                 and   OBJECT_VERSION_NUMBER=p_x_mr_relation_tbl(i).OBJECT_VERSION_NUMBER;

Line: 1067

                SELECT  AHL_MR_RELATIONSHIPS_S.NEXTVAL
                        INTO p_x_mr_relation_tbl(i).MR_RELATIONSHIP_ID
                        FROM DUAL;

Line: 1075

                  insert into AHl_mr_RELATIONSHIPS(
                                        MR_RELATIONSHIP_ID,
                                        OBJECT_VERSION_NUMBER,
                                        LAST_UPDATE_DATE,
                                        LAST_UPDATED_BY,
                                        CREATION_DATE,
                                        CREATED_BY,
                                        LAST_UPDATE_LOGIN,
                                        MR_HEADER_ID,
                                        RELATED_MR_HEADER_ID,
                                        RELATIONSHIP_CODE,
                                        ATTRIBUTE_CATEGORY,
                                        ATTRIBUTE1,
                                        ATTRIBUTE2,
                                        ATTRIBUTE3,
                                        ATTRIBUTE4,
                                        ATTRIBUTE5,
                                        ATTRIBUTE6,
                                        ATTRIBUTE7,
                                        ATTRIBUTE8,
                                        ATTRIBUTE9,
                                        ATTRIBUTE10,
                                        ATTRIBUTE11,
                                        ATTRIBUTE12,
                                        ATTRIBUTE13,
                                        ATTRIBUTE14,
                                        ATTRIBUTE15)
                                        values(
                                        p_x_mr_relation_tbl(i).MR_RELATIONSHIP_ID,
                                        1,
                                        sysdate,
                                        fnd_global.user_id,
                                        SYSDATE,
                                        fnd_global.user_id,
                                        fnd_global.user_id,
                                        p_x_mr_relation_tbl(i).MR_HEADER_ID,
                                        p_x_mr_relation_tbl(i).RELATED_MR_HEADER_ID,
                                        p_x_mr_relation_tbl(i).RELATIONSHIP_CODE,
                                        p_x_mr_relation_tbl(i).ATTRIBUTE_CATEGORY,
                                        p_x_mr_relation_tbl(i).ATTRIBUTE1,
                                        p_x_mr_relation_tbl(i).ATTRIBUTE2,
                                        p_x_mr_relation_tbl(i).ATTRIBUTE3,
                                        p_x_mr_relation_tbl(i).ATTRIBUTE4,
                                        p_x_mr_relation_tbl(i).ATTRIBUTE5,
                                        p_x_mr_relation_tbl(i).ATTRIBUTE6,
                                        p_x_mr_relation_tbl(i).ATTRIBUTE7,
                                        p_x_mr_relation_tbl(i).ATTRIBUTE8,
                                        p_x_mr_relation_tbl(i).ATTRIBUTE9,
                                        p_x_mr_relation_tbl(i).ATTRIBUTE10,
                                        p_x_mr_relation_tbl(i).ATTRIBUTE11,
                                        p_x_mr_relation_tbl(i).ATTRIBUTE12,
                                        p_x_mr_relation_tbl(i).ATTRIBUTE13,
                                        p_x_mr_relation_tbl(i).ATTRIBUTE14,
                                        p_x_mr_relation_tbl(i).ATTRIBUTE15);