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_INFORMATION

Line 1211: l_classification hr_organization_information.org_information3%TYPE;

1207: l_pension_gross NUMBER;
1208: l_balance_defined_id NUMBER;
1209: l_ytd_val NUMBER;
1210: l_ptd_val NUMBER;
1211: l_classification hr_organization_information.org_information3%TYPE;
1212: l_message VARCHAR2(255);
1213: l_procedure VARCHAR2(100);
1214: l_80ccd_gross NUMBER ;
1215: l_80ccd_qa_amt NUMBER ;

Line 2446: FROM hr_organization_information hoi

2442: ,hou.name org_name
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

Line 2458: FROM hr_organization_information hoi

2454: CURSOR c_reg_org_details(p_reg_org_id NUMBER)
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

Line 2515: FROM hr_organization_information hoi

2511: ,DECODE(pep.title,NULL,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title)
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

Line 2560: l_tan hr_organization_information.org_information1%TYPE;

2556: WHERE parent_id = p_person_id
2557: AND phone_type = 'WF'
2558: AND p_effective_end_date BETWEEN date_from AND NVL(date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
2559:
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;

Line 2561: l_ward hr_organization_information.org_information2%TYPE;

2557: AND phone_type = 'WF'
2558: AND p_effective_end_date BETWEEN date_from AND NVL(date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
2559:
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;

Line 2562: l_reg_org_id hr_organization_information.org_information4%TYPE;

2558: AND p_effective_end_date BETWEEN date_from AND NVL(date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
2559:
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;

Line 2563: l_tan_ack_no hr_organization_information.org_information5%TYPE;

2559:
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;

Line 2566: l_pan hr_organization_information.org_information3%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;
2570: l_position per_all_positions.name%TYPE;

Line 2567: l_legal_name 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;
2570: l_position per_all_positions.name%TYPE;
2571: l_job per_jobs.name%TYPE;

Line 2584: l_emplr_type hr_organization_information.org_information3%TYPE;

2580: l_ovn NUMBER;
2581: l_message VARCHAR2(255);
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;

Line 2585: l_income_tax_org_id hr_organization_information.org_information16%TYPE;

2581: l_message VARCHAR2(255);
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:

Line 2587: l_dig_sign hr_organization_information.org_information17%TYPE;

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:
2591: BEGIN

Line 2588: l_image_form16 hr_organization_information.org_information18%TYPE;

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:
2591: BEGIN
2592: l_procedure := g_package ||'archive_org_data';