APPS.EDR_PSIG dependencies on EDR_PSIG_SIGN_PARAMS_VL

Line 1730: select parameter_id from EDR_PSIG_SIGN_PARAMS_VL

1726: l_parameter_id NUMBER;
1727: L_ROWID ROWID;
1728: L_PARAM_NAME VARCHAR2(240);
1729: CURSOR C1 IS
1730: select parameter_id from EDR_PSIG_SIGN_PARAMS_VL
1731: where signature_id=P_SIGNATURE_ID and
1732: NAME=L_PARAM_NAME;
1733:
1734: BEGIN

Line 1982: from EDR_PSIG_SIGN_PARAMS_VL

1978: l_parameter_id NUMBER;
1979: i number;
1980: CURSOR SIGN_PARAMS
1981: is SELECT PARAMETER_ID
1982: from EDR_PSIG_SIGN_PARAMS_VL
1983: where SIGNATURE_ID =P_SIGNATURE_ID;
1984: CURSOR SIG_PARAMS
1985: is SELECT NAME,VALUE,DISPLAY_NAME
1986: from EDR_PSIG_SIGN_PARAMS_VL

Line 1986: from EDR_PSIG_SIGN_PARAMS_VL

1982: from EDR_PSIG_SIGN_PARAMS_VL
1983: where SIGNATURE_ID =P_SIGNATURE_ID;
1984: CURSOR SIG_PARAMS
1985: is SELECT NAME,VALUE,DISPLAY_NAME
1986: from EDR_PSIG_SIGN_PARAMS_VL
1987: where SIGNATURE_ID=P_SIGNATURE_ID;
1988: CURSOR SIGN_DETAILS
1989: is SELECT SIGNATURE_ID,
1990: DOCUMENT_ID,

Line 2626: from edr_psig_sign_params_vl param1

2622: xmlforest(param1.name as PARAM_NAME,
2623: param1.value as PARAM_VALUE)
2624: )
2625: )
2626: from edr_psig_sign_params_vl param1
2627: where param1.signature_id = psig.signature_id
2628: ) as SIGNATURE_PARAM_DETAILS
2629: )
2630: )