DBA Data[Home] [Help]

APPS.PER_RI_CONFIG_FND_HR_ENTITY dependencies on PER_RI_CONFIG_RESPONSIBILITY

Line 3722: from per_ri_config_responsibility)

3718: select country_code
3719: from per_ri_config_country_v
3720: where configuration_code = cp_configuration_code
3721: and country_code in (select distinct territory_code
3722: from per_ri_config_responsibility)
3723: and country_code in (select per_ri_config_utilities.business_group_decision
3724: (cp_configuration_code
3725: ,country_code)
3726: from per_ri_config_country_v where configuration_code = cp_configuration_code);

Line 3734: from per_ri_config_responsibility);

3730: select country_code
3731: from per_ri_config_country_v
3732: where configuration_code = cp_configuration_code
3733: and country_code in (select distinct territory_code
3734: from per_ri_config_responsibility);
3735: */
3736:
3737: cursor csr_get_product (cp_configuration_code in varchar2) IS
3738: select product_name

Line 3748: per_ri_config_responsibility con,

3744: select distinct resp.responsibility_key,
3745: apps.application_short_name
3746: from fnd_application apps,
3747: fnd_responsibility resp,
3748: per_ri_config_responsibility con,
3749: per_ri_config_country_v cont
3750: where apps.application_id = resp.application_id
3751: and con.responsibility_key = resp.responsibility_key
3752: and resp.responsibility_key = con.responsibility_key

Line 3758: from per_ri_config_responsibility);

3754: and con.territory_code = cp_territory_code
3755: and con.responsibility_application = cp_responsibility_application
3756: and con.territory_code = cont.country_code
3757: and cont.country_code in (select distinct territory_code
3758: from per_ri_config_responsibility);
3759:
3760: cursor csr_global_responsibility(cp_configuration_code in varchar2) IS
3761: select country_code
3762: from per_ri_config_country_v con

Line 3765: from per_ri_config_responsibility)

3761: select country_code
3762: from per_ri_config_country_v con
3763: where con.configuration_code = cp_configuration_code
3764: and con.country_code not in (select distinct territory_code
3765: from per_ri_config_responsibility)
3766: and per_ri_config_utilities.business_group_decision
3767: (cp_configuration_code
3768: ,country_code) <> 'INT' ;
3769: