DBA Data[Home] [Help]

APPS.QA_PLAN_ELEMENT_API dependencies on GMP_PROCESS_PARAMETERS

Line 1870: FROM GMP_PROCESS_PARAMETERS GP, GME_PROCESS_PARAMETERS GE

1866: RETURN NUMBER IS
1867: id NUMBER;
1868: CURSOR c (l_parameter VARCHAR2, l_resource_id NUMBER) is
1869: SELECT GP.PARAMETER_ID
1870: FROM GMP_PROCESS_PARAMETERS GP, GME_PROCESS_PARAMETERS GE
1871: WHERE GP.PARAMETER_NAME = L_PARAMETER
1872: AND GP.PARAMETER_ID = GE.PARAMETER_ID
1873: AND GE.BATCHSTEP_RESOURCE_ID= L_RESOURCE_ID;
1874: BEGIN

Line 4358: 'FROM GMP_PROCESS_PARAMETERS GP,GME_PROCESS_PARAMETERS GE '||

4354: BEGIN
4355: wild := value;
4356:
4357: sql_string := 'SELECT GP.PARAMETER_NAME, GP.PARAMETER_DESCRIPTION '||
4358: 'FROM GMP_PROCESS_PARAMETERS GP,GME_PROCESS_PARAMETERS GE '||
4359: 'WHERE GE.RESOURCES = :1 '||
4360: 'AND GE.PARAMETER_ID = GP.PARAMETER_ID '||
4361: 'AND GP.PARAMETER_NAME like :2';
4362: