DBA Data[Home] [Help]

APPS.PER_RI_CONFIG_FND_HR_ENTITY dependencies on PER_RI_CONFIG_COUNTRY_V

Line 3779: from per_ri_config_country_v

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

Line 3786: from per_ri_config_country_v where configuration_code = cp_configuration_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);
3787:
3788: /*
3789: cursor csr_get_country (cp_configuration_code in varchar2) IS
3790: select country_code

Line 3791: from per_ri_config_country_v

3787:
3788: /*
3789: cursor csr_get_country (cp_configuration_code in varchar2) IS
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: */

Line 3809: per_ri_config_country_v cont

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

Line 3822: from per_ri_config_country_v con

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