DBA Data[Home] [Help]

APPS.BISVIEWER SQL Statements

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

Line: 99

    select application_id
    from fnd_responsibility
    where responsibility_id=pRespId;
Line: 153

       SELECT responsibility_id INTO vResponsibilityId
       FROM   bis_scheduler
       WHERE  schedule_Id = pScheduleId;
Line: 226

    select function_id
    into functionid
    from fnd_form_functions
    where function_name = 'BIS_PMV_OA_JSP';
Line: 249

    select function_id
    into functionid
    from fnd_form_functions
    where function_name = 'BIS_PMV_REPORT_JSP';
Line: 555

    select application_id
    from fnd_responsibility
    where responsibility_id=pRespId;
Line: 594

       SELECT responsibility_id INTO vResponsibilityId
       FROM   bis_scheduler
       WHERE  schedule_Id = pScheduleId;
Line: 622

    select function_id
    into functionid
    from fnd_form_functions
    where function_name = 'BIS_PMV_REPORT_JSP';