DBA Data[Home] [Help]

APPS.QA_PLAN_ELEMENT_API dependencies on GMP_PROCESS_PARAMETERS

Line 1889: FROM GMP_PROCESS_PARAMETERS GP, GME_PROCESS_PARAMETERS GE

1885: RETURN NUMBER IS
1886: id NUMBER;
1887: CURSOR c (l_parameter VARCHAR2, l_resource_id NUMBER) is
1888: SELECT GP.PARAMETER_ID
1889: FROM GMP_PROCESS_PARAMETERS GP, GME_PROCESS_PARAMETERS GE
1890: WHERE GP.PARAMETER_NAME = L_PARAMETER
1891: AND GP.PARAMETER_ID = GE.PARAMETER_ID
1892: AND GE.BATCHSTEP_RESOURCE_ID= L_RESOURCE_ID;
1893: BEGIN

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

4552: BEGIN
4553: wild := value;
4554:
4555: sql_string := 'SELECT GP.PARAMETER_NAME, GP.PARAMETER_DESCRIPTION '||
4556: 'FROM GMP_PROCESS_PARAMETERS GP,GME_PROCESS_PARAMETERS GE '||
4557: 'WHERE GE.RESOURCES = :1 '||
4558: 'AND GE.PARAMETER_ID = GP.PARAMETER_ID '||
4559: 'AND GP.PARAMETER_NAME like :2';
4560: