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 1203: l_classification hr_organization_information.org_information3%TYPE;

1199: l_pension_gross NUMBER;
1200: l_balance_defined_id NUMBER;
1201: l_ytd_val NUMBER;
1202: l_ptd_val NUMBER;
1203: l_classification hr_organization_information.org_information3%TYPE;
1204: l_message VARCHAR2(255);
1205: l_procedure VARCHAR2(100);
1206: l_80ccd_gross NUMBER ;
1207: l_80ccd_qa_amt NUMBER ;

Line 2388: FROM hr_organization_information hoi

2384: ,hoi.org_information4 reg_org_id
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

Line 2400: FROM hr_organization_information hoi

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

Line 2449: FROM hr_organization_information hoi

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

Line 2494: l_tan hr_organization_information.org_information1%TYPE;

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

Line 2495: l_ward hr_organization_information.org_information2%TYPE;

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

Line 2496: l_reg_org_id hr_organization_information.org_information4%TYPE;

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

Line 2497: l_tan_ack_no hr_organization_information.org_information5%TYPE;

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

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

Line 2501: l_legal_name 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;
2504: l_position per_all_positions.name%TYPE;
2505: l_rep_father per_all_people_f.full_name%TYPE;