[Home] [Help]
2443: ,hou.location_id location_id
2444: ,hoi.org_information17 dig_sign
2445: ,hoi.org_information18 image_f16
2446: FROM hr_organization_information hoi
2447: ,hr_organization_units hou
2448: WHERE hoi.organization_id = p_gre_id
2449: AND hoi.org_information_context = 'PER_IN_INCOME_TAX_DF'
2450: AND hou.organization_id = hoi.organization_id
2451: AND hou.business_group_id = g_bg_id
2455: IS
2456: SELECT hoi.org_information3 pan
2457: ,hoi.org_information4 legal_name
2458: FROM hr_organization_information hoi
2459: ,hr_organization_units hou
2460: WHERE hoi.organization_id = p_reg_org_id
2461: AND hoi.org_information_context = 'PER_IN_COMPANY_DF'
2462: AND hou.organization_id = hoi.organization_id
2463: AND hou.business_group_id = g_bg_id
2465:
2466: CURSOR c_income_tax_org_details(p_income_tax_org_id NUMBER)
2467: IS
2468: SELECT location_id
2469: FROM hr_organization_units
2470: WHERE organization_id = p_income_tax_org_id
2471: AND business_group_id = g_bg_id
2472: AND p_effective_end_date BETWEEN date_from AND NVL(date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
2473:
2512: ,SUBSTR(hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title)
2513: ,INSTR(hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title),' ',1)+1)) rep_name
2514: ,pep.title title
2515: FROM hr_organization_information hoi
2516: ,hr_organization_units hou
2517: ,per_all_people_f pep
2518: WHERE hoi.org_information_context = 'PER_IN_INCOME_TAX_REP_DF'
2519: AND hoi.organization_id = p_gre_id
2520: AND hou.organization_id = hoi.organization_id
2529: CURSOR c_rep_address(p_person_id NUMBER)
2530: IS
2531: SELECT hou.location_id rep_location
2532: FROM per_all_assignments_f asg
2533: ,hr_organization_units hou
2534: WHERE asg.person_id = p_person_id
2535: AND asg.primary_flag = 'Y'
2536: AND asg.business_group_id = g_bg_id
2537: AND hou.organization_id = asg.organization_id
2560: l_tan hr_organization_information.org_information1%TYPE;
2561: l_ward hr_organization_information.org_information2%TYPE;
2562: l_reg_org_id hr_organization_information.org_information4%TYPE;
2563: l_tan_ack_no hr_organization_information.org_information5%TYPE;
2564: l_org_name hr_organization_units.name%TYPE;
2565: l_location_id hr_organization_units.location_id%TYPE;
2566: l_pan hr_organization_information.org_information3%TYPE;
2567: l_legal_name hr_organization_information.org_information4%TYPE;
2568: l_rep_person_id per_all_people_f.person_id%TYPE;
2561: l_ward hr_organization_information.org_information2%TYPE;
2562: l_reg_org_id hr_organization_information.org_information4%TYPE;
2563: l_tan_ack_no hr_organization_information.org_information5%TYPE;
2564: l_org_name hr_organization_units.name%TYPE;
2565: l_location_id hr_organization_units.location_id%TYPE;
2566: l_pan hr_organization_information.org_information3%TYPE;
2567: l_legal_name hr_organization_information.org_information4%TYPE;
2568: l_rep_person_id per_all_people_f.person_id%TYPE;
2569: l_rep_name per_all_people_f.full_name%TYPE;
2569: l_rep_name per_all_people_f.full_name%TYPE;
2570: l_position per_all_positions.name%TYPE;
2571: l_job per_jobs.name%TYPE;
2572: l_rep_father per_all_people_f.full_name%TYPE;
2573: l_rep_location hr_organization_units.location_id%TYPE;
2574: l_rep_phone_no per_phones.phone_number%TYPE;
2575: l_phone_type per_phones.phone_type%TYPE;
2576: l_rep_father_title per_all_people_f.title%TYPE;
2577: l_rep_title per_all_people_f.title%TYPE;
2582: l_procedure VARCHAR2(100);
2583:
2584: l_emplr_type hr_organization_information.org_information3%TYPE;
2585: l_income_tax_org_id hr_organization_information.org_information16%TYPE;
2586: l_itax_location_id hr_organization_units.location_id%TYPE;
2587: l_dig_sign hr_organization_information.org_information17%TYPE;
2588: l_image_form16 hr_organization_information.org_information18%TYPE;
2589:
2590: