DBA Data[Home] [Help]

APPS.PN_VAR_TEMPLATE_PKG dependencies on DUAL

Line 72: FROM DUAL;

68:
69: IF ( X_AGREEMENT_TEMPLATE_ID IS NULL) THEN
70: Select PN_VAR_TEMPLATES_S.nextval
71: into X_AGREEMENT_TEMPLATE_ID
72: FROM DUAL;
73: END IF;
74:
75: insert into PN_VAR_TEMPLATES_ALL (
76: AGREEMENT_TEMPLATE_ID,

Line 686: FROM DUAL

682: l_dummy NUMBER;
683: BEGIN
684: SELECT 1
685: INTO l_dummy
686: FROM DUAL
687: WHERE NOT EXISTS (SELECT 1
688: FROM pn_var_templates_all
689: WHERE agreement_template = x_name
690: AND ((x_template_id IS NULL)