APPS.PAY_PPMV4_SS dependencies on HR_ORGANIZATION_INFORMATION

Line 3548: hr_organization_information org_inf,

3544: cp_business_group_id number) IS
3545: SELECT org_inf.org_information9,
3546: TERR.territory_short_name
3547: FROM hr_all_organization_units org,
3548: hr_organization_information org_inf,
3549: FND_TERRITORIES_VL TERR
3550: WHERE org.ORGANIZATION_ID = cp_business_group_id
3551: AND org.ORGANIZATION_ID = org_inf.ORGANIZATION_ID
3552: AND ORG_INFORMATION_CONTEXT = 'Business Group Information'

Line 3556: l_bg_country hr_organization_information.org_information9%TYPE;

3552: AND ORG_INFORMATION_CONTEXT = 'Business Group Information'
3553: AND org_inf.org_information9 = TERR.territory_code (+);
3554:
3555: l_ppt_territory_code pay_payment_types.territory_code%TYPE;
3556: l_bg_country hr_organization_information.org_information9%TYPE;
3557: l_territory_desc FND_TERRITORIES_VL.territory_short_name%TYPE;
3558:
3559: begin
3560: l_ppt_territory_code := null;

Line 3614: l_bank_country_code hr_organization_information.org_information9%TYPE;

3610: function get_bank_flexcode
3611: (p_org_payment_method_id IN number,
3612: p_business_group_id IN number)return varchar2 IS
3613:
3614: l_bank_country_code hr_organization_information.org_information9%TYPE;
3615:
3616: cursor c_get_flexcode (
3617: cp_opm_id number
3618: ,cp_bgid number ) IS