APPS.PQP_GB_PENSION_SCHEME_TEMPLATE dependencies on DUAL

Line 917: FROM DUAL;

913: UPPER (c_number)
914: ,'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'
915: ,'AAAAAAAAAAAAAAAAAAAAAAAAAA9999999999'
916: )
917: FROM DUAL;
918:
919:
920: l_proc_name VARCHAR2 (80) := g_proc_name
921: || 'insert_validate';

Line 3422: FROM DUAL

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

Line 3965: FROM DUAL

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

Line 3979: FROM DUAL

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