DBA Data[Home] [Help]

APPS.PER_RI_CONFIG_FND_HR_ENTITY dependencies on PER_RI_CONFIG_COUNTRY_V

Line 3719: from per_ri_config_country_v

3715: ,p_hrms_resp_tab in out nocopy per_ri_config_tech_summary.hrms_resp_tab) IS
3716:
3717: cursor csr_get_country (cp_configuration_code in varchar2) IS
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

Line 3726: from per_ri_config_country_v where configuration_code = cp_configuration_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);
3727:
3728: /*
3729: cursor csr_get_country (cp_configuration_code in varchar2) IS
3730: select country_code

Line 3731: from per_ri_config_country_v

3727:
3728: /*
3729: cursor csr_get_country (cp_configuration_code in varchar2) IS
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: */

Line 3749: per_ri_config_country_v cont

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
3753: and resp.responsibility_key = con.responsibility_key

Line 3762: from per_ri_config_country_v con

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
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