DBA Data[Home] [Help]

APPS.PER_RI_CONFIG_FND_HR_ENTITY dependencies on PER_RI_CONFIG_RESPONSIBILITY

Line 3782: from per_ri_config_responsibility)

3778: select country_code
3779: from per_ri_config_country_v
3780: where configuration_code = cp_configuration_code
3781: and country_code in (select distinct territory_code
3782: from per_ri_config_responsibility)
3783: and country_code in (select per_ri_config_utilities.business_group_decision
3784: (cp_configuration_code
3785: ,country_code)
3786: from per_ri_config_country_v where configuration_code = cp_configuration_code);

Line 3794: from per_ri_config_responsibility);

3790: select country_code
3791: from per_ri_config_country_v
3792: where configuration_code = cp_configuration_code
3793: and country_code in (select distinct territory_code
3794: from per_ri_config_responsibility);
3795: */
3796:
3797: cursor csr_get_product (cp_configuration_code in varchar2) IS
3798: select product_name

Line 3808: per_ri_config_responsibility con,

3804: select distinct resp.responsibility_key,
3805: apps.application_short_name
3806: from fnd_application apps,
3807: fnd_responsibility resp,
3808: per_ri_config_responsibility con,
3809: per_ri_config_country_v cont
3810: where apps.application_id = resp.application_id
3811: and con.responsibility_key = resp.responsibility_key
3812: and resp.responsibility_key = con.responsibility_key

Line 3818: from per_ri_config_responsibility);

3814: and con.territory_code = cp_territory_code
3815: and con.responsibility_application = cp_responsibility_application
3816: and con.territory_code = cont.country_code
3817: and cont.country_code in (select distinct territory_code
3818: from per_ri_config_responsibility);
3819:
3820: cursor csr_global_responsibility(cp_configuration_code in varchar2) IS
3821: select country_code
3822: from per_ri_config_country_v con

Line 3825: from per_ri_config_responsibility)

3821: select country_code
3822: from per_ri_config_country_v con
3823: where con.configuration_code = cp_configuration_code
3824: and con.country_code not in (select distinct territory_code
3825: from per_ri_config_responsibility)
3826: and per_ri_config_utilities.business_group_decision
3827: (cp_configuration_code
3828: ,country_code) <> 'INT' ;
3829: