APPS.PAY_PPMV4_SS dependencies on HR_ORGANIZATION_INFORMATION

Line 3884: hr_organization_information org_inf,

3880: cp_business_group_id number) IS
3881: SELECT org_inf.org_information9,
3882: TERR.territory_short_name
3883: FROM hr_all_organization_units org,
3884: hr_organization_information org_inf,
3885: FND_TERRITORIES_VL TERR
3886: WHERE org.ORGANIZATION_ID = cp_business_group_id
3887: AND org.ORGANIZATION_ID = org_inf.ORGANIZATION_ID
3888: AND ORG_INFORMATION_CONTEXT = 'Business Group Information'

Line 3892: l_bg_country hr_organization_information.org_information9%TYPE;

3888: AND ORG_INFORMATION_CONTEXT = 'Business Group Information'
3889: AND org_inf.org_information9 = TERR.territory_code (+);
3890:
3891: l_ppt_territory_code pay_payment_types.territory_code%TYPE;
3892: l_bg_country hr_organization_information.org_information9%TYPE;
3893: l_territory_desc FND_TERRITORIES_VL.territory_short_name%TYPE;
3894:
3895: begin
3896: l_ppt_territory_code := null;

Line 3950: l_bank_country_code hr_organization_information.org_information9%TYPE;

3946: function get_bank_flexcode
3947: (p_org_payment_method_id IN number,
3948: p_business_group_id IN number)return varchar2 IS
3949:
3950: l_bank_country_code hr_organization_information.org_information9%TYPE;
3951:
3952: cursor c_get_flexcode (
3953: cp_opm_id number
3954: ,cp_bgid number ) IS