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_EMP_ACTION_ARCH dependencies on HR_ORGANIZATION_INFORMATION

Line 760: from hr_organization_information

756: select org_information1, org_information2,
757: org_information3, org_information4,
758: org_information5, org_information6,
759: org_information7
760: from hr_organization_information
761: where org_information_context = cp_org_info_context
762: and organization_id = cp_organization_id;
763:
764: cursor c_element_details(cp_element_type_id number

Line 2255: from hr_organization_information hri

2251: hri.org_information2, hri.org_information3,
2252: hri.org_information4, hri.org_information5,
2253: hri.org_information6, hri.org_information7,
2254: org_information_context ----Bug 7115367
2255: from hr_organization_information hri
2256: where hri.organization_id = cp_organization_id
2257: and hri.org_information_context = cp_org_information_context
2258: and hri.org_information1 = 'MESG';
2259:

Line 2260: lv_org_information1 hr_organization_information.org_information1%type;

2256: where hri.organization_id = cp_organization_id
2257: and hri.org_information_context = cp_org_information_context
2258: and hri.org_information1 = 'MESG';
2259:
2260: lv_org_information1 hr_organization_information.org_information1%type;
2261: lv_org_information2 hr_organization_information.org_information2%type;
2262: lv_org_information3 hr_organization_information.org_information3%type;
2263: lv_org_information4 hr_organization_information.org_information4%type;
2264: lv_org_information5 hr_organization_information.org_information5%type;

Line 2261: lv_org_information2 hr_organization_information.org_information2%type;

2257: and hri.org_information_context = cp_org_information_context
2258: and hri.org_information1 = 'MESG';
2259:
2260: lv_org_information1 hr_organization_information.org_information1%type;
2261: lv_org_information2 hr_organization_information.org_information2%type;
2262: lv_org_information3 hr_organization_information.org_information3%type;
2263: lv_org_information4 hr_organization_information.org_information4%type;
2264: lv_org_information5 hr_organization_information.org_information5%type;
2265: lv_org_information6 hr_organization_information.org_information6%type;

Line 2262: lv_org_information3 hr_organization_information.org_information3%type;

2258: and hri.org_information1 = 'MESG';
2259:
2260: lv_org_information1 hr_organization_information.org_information1%type;
2261: lv_org_information2 hr_organization_information.org_information2%type;
2262: lv_org_information3 hr_organization_information.org_information3%type;
2263: lv_org_information4 hr_organization_information.org_information4%type;
2264: lv_org_information5 hr_organization_information.org_information5%type;
2265: lv_org_information6 hr_organization_information.org_information6%type;
2266: lv_org_information7 hr_organization_information.org_information7%type;

Line 2263: lv_org_information4 hr_organization_information.org_information4%type;

2259:
2260: lv_org_information1 hr_organization_information.org_information1%type;
2261: lv_org_information2 hr_organization_information.org_information2%type;
2262: lv_org_information3 hr_organization_information.org_information3%type;
2263: lv_org_information4 hr_organization_information.org_information4%type;
2264: lv_org_information5 hr_organization_information.org_information5%type;
2265: lv_org_information6 hr_organization_information.org_information6%type;
2266: lv_org_information7 hr_organization_information.org_information7%type;
2267: lv_org_information_cntxt hr_organization_information.org_information_context%type; ----Bug 7115367

Line 2264: lv_org_information5 hr_organization_information.org_information5%type;

2260: lv_org_information1 hr_organization_information.org_information1%type;
2261: lv_org_information2 hr_organization_information.org_information2%type;
2262: lv_org_information3 hr_organization_information.org_information3%type;
2263: lv_org_information4 hr_organization_information.org_information4%type;
2264: lv_org_information5 hr_organization_information.org_information5%type;
2265: lv_org_information6 hr_organization_information.org_information6%type;
2266: lv_org_information7 hr_organization_information.org_information7%type;
2267: lv_org_information_cntxt hr_organization_information.org_information_context%type; ----Bug 7115367
2268:

Line 2265: lv_org_information6 hr_organization_information.org_information6%type;

2261: lv_org_information2 hr_organization_information.org_information2%type;
2262: lv_org_information3 hr_organization_information.org_information3%type;
2263: lv_org_information4 hr_organization_information.org_information4%type;
2264: lv_org_information5 hr_organization_information.org_information5%type;
2265: lv_org_information6 hr_organization_information.org_information6%type;
2266: lv_org_information7 hr_organization_information.org_information7%type;
2267: lv_org_information_cntxt hr_organization_information.org_information_context%type; ----Bug 7115367
2268:
2269: ln_index NUMBER;

Line 2266: lv_org_information7 hr_organization_information.org_information7%type;

2262: lv_org_information3 hr_organization_information.org_information3%type;
2263: lv_org_information4 hr_organization_information.org_information4%type;
2264: lv_org_information5 hr_organization_information.org_information5%type;
2265: lv_org_information6 hr_organization_information.org_information6%type;
2266: lv_org_information7 hr_organization_information.org_information7%type;
2267: lv_org_information_cntxt hr_organization_information.org_information_context%type; ----Bug 7115367
2268:
2269: ln_index NUMBER;
2270: lv_exists VARCHAR2(1);

Line 2267: lv_org_information_cntxt hr_organization_information.org_information_context%type; ----Bug 7115367

2263: lv_org_information4 hr_organization_information.org_information4%type;
2264: lv_org_information5 hr_organization_information.org_information5%type;
2265: lv_org_information6 hr_organization_information.org_information6%type;
2266: lv_org_information7 hr_organization_information.org_information7%type;
2267: lv_org_information_cntxt hr_organization_information.org_information_context%type; ----Bug 7115367
2268:
2269: ln_index NUMBER;
2270: lv_exists VARCHAR2(1);
2271: lv_procedure_name VARCHAR2(100);