eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_EOY_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 2389: ,hr_organization_units hou

2385: ,hoi.org_information5 tan_ack_no
2386: ,hou.name org_name
2387: ,hou.location_id location_id
2388: FROM hr_organization_information hoi
2389: ,hr_organization_units hou
2390: WHERE hoi.organization_id = p_gre_id
2391: AND hoi.org_information_context = 'PER_IN_INCOME_TAX_DF'
2392: AND hou.organization_id = hoi.organization_id
2393: AND hou.business_group_id = g_bg_id

Line 2401: ,hr_organization_units hou

2397: IS
2398: SELECT hoi.org_information3 pan
2399: ,hoi.org_information4 legal_name
2400: FROM hr_organization_information hoi
2401: ,hr_organization_units hou
2402: WHERE hoi.organization_id = p_reg_org_id
2403: AND hoi.org_information_context = 'PER_IN_COMPANY_DF'
2404: AND hou.organization_id = hoi.organization_id
2405: AND hou.business_group_id = g_bg_id

Line 2450: ,hr_organization_units hou

2446: ,SUBSTR(hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title)
2447: ,INSTR(hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title),' ',1)+1)) rep_name
2448: ,pep.title title
2449: FROM hr_organization_information hoi
2450: ,hr_organization_units hou
2451: ,per_all_people_f pep
2452: WHERE hoi.org_information_context = 'PER_IN_INCOME_TAX_REP_DF'
2453: AND hoi.organization_id = p_gre_id
2454: AND hou.organization_id = hoi.organization_id

Line 2467: ,hr_organization_units hou

2463: CURSOR c_rep_address(p_person_id NUMBER)
2464: IS
2465: SELECT hou.location_id rep_location
2466: FROM per_all_assignments_f asg
2467: ,hr_organization_units hou
2468: WHERE asg.person_id = p_person_id
2469: AND asg.primary_flag = 'Y'
2470: AND asg.business_group_id = g_bg_id
2471: AND hou.organization_id = asg.organization_id

Line 2498: l_org_name hr_organization_units.name%TYPE;

2494: l_tan hr_organization_information.org_information1%TYPE;
2495: l_ward hr_organization_information.org_information2%TYPE;
2496: l_reg_org_id hr_organization_information.org_information4%TYPE;
2497: l_tan_ack_no hr_organization_information.org_information5%TYPE;
2498: l_org_name hr_organization_units.name%TYPE;
2499: l_location_id hr_organization_units.location_id%TYPE;
2500: l_pan hr_organization_information.org_information3%TYPE;
2501: l_legal_name hr_organization_information.org_information4%TYPE;
2502: l_rep_person_id per_all_people_f.person_id%TYPE;

Line 2499: l_location_id hr_organization_units.location_id%TYPE;

2495: l_ward hr_organization_information.org_information2%TYPE;
2496: l_reg_org_id hr_organization_information.org_information4%TYPE;
2497: l_tan_ack_no hr_organization_information.org_information5%TYPE;
2498: l_org_name hr_organization_units.name%TYPE;
2499: l_location_id hr_organization_units.location_id%TYPE;
2500: l_pan hr_organization_information.org_information3%TYPE;
2501: l_legal_name hr_organization_information.org_information4%TYPE;
2502: l_rep_person_id per_all_people_f.person_id%TYPE;
2503: l_rep_name per_all_people_f.full_name%TYPE;

Line 2506: l_rep_location hr_organization_units.location_id%TYPE;

2502: l_rep_person_id per_all_people_f.person_id%TYPE;
2503: l_rep_name per_all_people_f.full_name%TYPE;
2504: l_position per_all_positions.name%TYPE;
2505: l_rep_father per_all_people_f.full_name%TYPE;
2506: l_rep_location hr_organization_units.location_id%TYPE;
2507: l_rep_phone_no per_phones.phone_number%TYPE;
2508: l_phone_type per_phones.phone_type%TYPE;
2509: l_rep_father_title per_all_people_f.title%TYPE;
2510: l_rep_title per_all_people_f.title%TYPE;