APPS.PAY_FR_RULES dependencies on HR_ALL_ORGANIZATION_UNITS

Line 196: l_company_id hr_all_organization_units.ORGANIZATION_ID%TYPE;

192: IS
193: l_gen_org_method_id_chr varchar2(60);
194: l_map_tbl_ind BINARY_INTEGER;
195: l_dummy_opm_id pay_org_payment_methods_f.ORG_PAYMENT_METHOD_ID%TYPE;
196: l_company_id hr_all_organization_units.ORGANIZATION_ID%TYPE;
197: --
198: cursor csr_get_estab is
199: select tax_unit_id
200: from pay_assignment_actions

Line 224: from hr_all_organization_units_tl org,

220: and language = userenv('LANG');
221: --
222: cursor csr_get_org_info is
223: select substrb(NAME,1,60), substrb(hrl.meaning,1,20)
224: from hr_all_organization_units_tl org,
225: hr_organization_information ori,
226: hr_lookups hrl
227: where org.ORGANIZATION_ID = p_org_id
228: and org.language = userenv('LANG')

Line 270: hr_all_organization_units org

266: BEGIN
267: SELECT fnd_number.canonical_to_number(hoi.ORG_INFORMATION1)
268: INTO p_org_method_id
269: FROM hr_organization_information hoi,
270: hr_all_organization_units org
271: WHERE hoi.organization_id = g_estab_id
272: AND hoi.ORG_INFORMATION2 = l_gen_org_method_id_chr
273: AND hoi.org_information_context = 'FR_DYN_PAYMETH_MAPPING_INFO'
274: AND hoi.organization_id = org.organization_id

Line 301: hr_all_organization_units org

297:
298: SELECT fnd_number.canonical_to_number(hoi.ORG_INFORMATION1)
299: INTO p_org_method_id
300: FROM hr_organization_information hoi,
301: hr_all_organization_units org
302: WHERE hoi.organization_id = l_company_id
303: AND hoi.ORG_INFORMATION2 = l_gen_org_method_id_chr
304: AND hoi.org_information_context = 'FR_DYN_PAYMETH_MAPPING_INFO'
305: AND hoi.organization_id = org.organization_id