APPS.PQH_PA_WHATIF_PROCESS dependencies on PQH_ROLE_EXTRA_INFO

Line 3425: From pqh_role_extra_info ,

3421: and hierarchy_type='OIPLIP';
3422:
3423: Cursor check_setup(p_oipl_id NUMBER) IS
3424: Select information3
3425: From pqh_role_extra_info ,
3426: ben_oiplip_f
3427: Where oipl_id=p_oipl_id
3428: and plip_id=p_plip_id
3429: and g_effective_date between effective_start_date and effective_end_date

Line 3469: From pqh_role_extra_info

3465: and hierarchy_type='PLIP';
3466:
3467: Cursor check_setup(p_plip_id NUMBER) IS
3468: Select information3
3469: From pqh_role_extra_info
3470: Where role_id=g_role_id
3471: and information_type='BEN_SS_ROLE_COMP_OBJECTS'
3472: and information1='PLIP'
3473: and information2=to_char(p_plip_id);

Line 3515: From pqh_role_extra_info

3511: and hierarchy_type='PTIP';
3512:
3513: Cursor check_setup(p_ptip_id NUMBER) IS
3514: Select information3
3515: From pqh_role_extra_info
3516: Where role_id=g_role_id
3517: and information_type='BEN_SS_ROLE_COMP_OBJECTS'
3518: and information1='PTIP'
3519: and information2=to_char(p_ptip_id);

Line 3557: From pqh_role_extra_info

3553: and hierarchy_type='PGM';
3554:
3555: Cursor check_setup(p_pgm_id NUMBER) IS
3556: Select information3
3557: From pqh_role_extra_info
3558: Where role_id=g_role_id
3559: and information_type='BEN_SS_ROLE_COMP_OBJECTS'
3560: and information1='PGM'
3561: and information2=p_pgm_id;

Line 3599: From pqh_role_extra_info

3595: and hierarchy_type='OIPNIP';
3596:
3597: Cursor check_setup(p_oipnip_id NUMBER) IS
3598: Select information3
3599: From pqh_role_extra_info
3600: Where role_id=g_role_id
3601: and information_type='BEN_SS_ROLE_COMP_OBJECTS'
3602: and information1='OIPNIP'
3603: and information2=to_char(p_oipnip_id);

Line 3640: From pqh_role_extra_info

3636: and hierarchy_type='PNIP';
3637:
3638: Cursor check_setup(p_pnip_id NUMBER) IS
3639: Select information3
3640: From pqh_role_extra_info
3641: Where role_id=g_role_id
3642: and information_type='BEN_SS_ROLE_COMP_OBJECTS'
3643: and information1='PNIP'
3644: and information2=to_char(p_pnip_id);

Line 3682: From pqh_role_extra_info

3678: and hierarchy_type='PT';
3679:
3680: Cursor check_setup(p_pl_typ_id NUMBER) IS
3681: Select information3
3682: From pqh_role_extra_info
3683: Where role_id=g_role_id
3684: and information_type='BEN_SS_ROLE_COMP_OBJECTS'
3685: and information1='PT'
3686: and information2=p_pl_typ_id;

Line 3711: From pqh_role_extra_info

3707: IS
3708: l_dummy NUMBER :=0;
3709: Cursor csr_verify_setup IS
3710: Select 1
3711: From pqh_role_extra_info
3712: Where role_id=g_role_id
3713: and information_type='BEN_SS_ROLE_COMP_OBJECTS'
3714: and information1 <> 'LE';
3715: BEGIN