APPS.PQP_GB_PENSION_SCHEME_TEMPLATE dependencies on DUAL

Line 913: FROM DUAL;

909: UPPER (c_number)
910: ,'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'
911: ,'AAAAAAAAAAAAAAAAAAAAAAAAAA9999999999'
912: )
913: FROM DUAL;
914:
915:
916: l_proc_name VARCHAR2 (80) := g_proc_name
917: || 'insert_validate';

Line 3420: FROM DUAL

3416: --
3417: CURSOR csr_chk_uniq_sch_name
3418: IS
3419: SELECT 'X'
3420: FROM DUAL
3421: WHERE EXISTS ( SELECT 1
3422: FROM pay_element_type_extra_info eei
3423: ,pay_element_types_f pet
3424: WHERE pet.element_type_id = eei.element_type_id

Line 3962: FROM DUAL

3958:
3959: CURSOR csr_chk_ocp_asoc_avc
3960: IS
3961: SELECT 'X'
3962: FROM DUAL
3963: WHERE EXISTS ( SELECT 1
3964: FROM pqp_gb_pension_schemes_v
3965: WHERE ( associated_ocp_ele_type_id IS NOT NULL
3966: AND associated_ocp_ele_type_id =

Line 3976: FROM DUAL

3972: -- for this pension scheme
3973: CURSOR csr_chk_fr_exists
3974: IS
3975: SELECT 'X'
3976: FROM DUAL
3977: WHERE EXISTS ( SELECT 1
3978: FROM pay_element_templates
3979: WHERE base_name = p_ele_base_name
3980: || ' Fixed'