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 799: from hr_organization_information

795: select org_information1, org_information2,
796: org_information3, org_information4,
797: org_information5, org_information6,
798: org_information7
799: from hr_organization_information
800: where org_information_context = cp_org_info_context
801: and organization_id = cp_organization_id;
802:
803: cursor c_element_details(cp_element_type_id number

Line 1778: from hr_organization_information

1774: where soft_coding_keyflex_id = cp_soft_coding_keyflex_id;
1775:
1776: cursor c_legislation (cp_business_group_id in number) is
1777: select org_information9
1778: from hr_organization_information
1779: where org_information_context = 'Business Group Information'
1780: and organization_id = cp_business_group_id;
1781:
1782: cursor c_get_shift_desc(cp_shift_code in varchar2

Line 2350: from hr_organization_information hri

2346: hri.org_information2, hri.org_information3,
2347: hri.org_information4, hri.org_information5,
2348: hri.org_information6, hri.org_information7,
2349: org_information_context ----Bug 7115367
2350: from hr_organization_information hri
2351: where hri.organization_id = cp_organization_id
2352: and hri.org_information_context = cp_org_information_context
2353: and hri.org_information1 = 'MESG';
2354:

Line 2355: lv_org_information1 hr_organization_information.org_information1%type;

2351: where hri.organization_id = cp_organization_id
2352: and hri.org_information_context = cp_org_information_context
2353: and hri.org_information1 = 'MESG';
2354:
2355: lv_org_information1 hr_organization_information.org_information1%type;
2356: lv_org_information2 hr_organization_information.org_information2%type;
2357: lv_org_information3 hr_organization_information.org_information3%type;
2358: lv_org_information4 hr_organization_information.org_information4%type;
2359: lv_org_information5 hr_organization_information.org_information5%type;

Line 2356: lv_org_information2 hr_organization_information.org_information2%type;

2352: and hri.org_information_context = cp_org_information_context
2353: and hri.org_information1 = 'MESG';
2354:
2355: lv_org_information1 hr_organization_information.org_information1%type;
2356: lv_org_information2 hr_organization_information.org_information2%type;
2357: lv_org_information3 hr_organization_information.org_information3%type;
2358: lv_org_information4 hr_organization_information.org_information4%type;
2359: lv_org_information5 hr_organization_information.org_information5%type;
2360: lv_org_information6 hr_organization_information.org_information6%type;

Line 2357: lv_org_information3 hr_organization_information.org_information3%type;

2353: and hri.org_information1 = 'MESG';
2354:
2355: lv_org_information1 hr_organization_information.org_information1%type;
2356: lv_org_information2 hr_organization_information.org_information2%type;
2357: lv_org_information3 hr_organization_information.org_information3%type;
2358: lv_org_information4 hr_organization_information.org_information4%type;
2359: lv_org_information5 hr_organization_information.org_information5%type;
2360: lv_org_information6 hr_organization_information.org_information6%type;
2361: lv_org_information7 hr_organization_information.org_information7%type;

Line 2358: lv_org_information4 hr_organization_information.org_information4%type;

2354:
2355: lv_org_information1 hr_organization_information.org_information1%type;
2356: lv_org_information2 hr_organization_information.org_information2%type;
2357: lv_org_information3 hr_organization_information.org_information3%type;
2358: lv_org_information4 hr_organization_information.org_information4%type;
2359: lv_org_information5 hr_organization_information.org_information5%type;
2360: lv_org_information6 hr_organization_information.org_information6%type;
2361: lv_org_information7 hr_organization_information.org_information7%type;
2362: lv_org_information_cntxt hr_organization_information.org_information_context%type; ----Bug 7115367

Line 2359: lv_org_information5 hr_organization_information.org_information5%type;

2355: lv_org_information1 hr_organization_information.org_information1%type;
2356: lv_org_information2 hr_organization_information.org_information2%type;
2357: lv_org_information3 hr_organization_information.org_information3%type;
2358: lv_org_information4 hr_organization_information.org_information4%type;
2359: lv_org_information5 hr_organization_information.org_information5%type;
2360: lv_org_information6 hr_organization_information.org_information6%type;
2361: lv_org_information7 hr_organization_information.org_information7%type;
2362: lv_org_information_cntxt hr_organization_information.org_information_context%type; ----Bug 7115367
2363:

Line 2360: lv_org_information6 hr_organization_information.org_information6%type;

2356: lv_org_information2 hr_organization_information.org_information2%type;
2357: lv_org_information3 hr_organization_information.org_information3%type;
2358: lv_org_information4 hr_organization_information.org_information4%type;
2359: lv_org_information5 hr_organization_information.org_information5%type;
2360: lv_org_information6 hr_organization_information.org_information6%type;
2361: lv_org_information7 hr_organization_information.org_information7%type;
2362: lv_org_information_cntxt hr_organization_information.org_information_context%type; ----Bug 7115367
2363:
2364: ln_index NUMBER;

Line 2361: lv_org_information7 hr_organization_information.org_information7%type;

2357: lv_org_information3 hr_organization_information.org_information3%type;
2358: lv_org_information4 hr_organization_information.org_information4%type;
2359: lv_org_information5 hr_organization_information.org_information5%type;
2360: lv_org_information6 hr_organization_information.org_information6%type;
2361: lv_org_information7 hr_organization_information.org_information7%type;
2362: lv_org_information_cntxt hr_organization_information.org_information_context%type; ----Bug 7115367
2363:
2364: ln_index NUMBER;
2365: lv_exists VARCHAR2(1);

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

2358: lv_org_information4 hr_organization_information.org_information4%type;
2359: lv_org_information5 hr_organization_information.org_information5%type;
2360: lv_org_information6 hr_organization_information.org_information6%type;
2361: lv_org_information7 hr_organization_information.org_information7%type;
2362: lv_org_information_cntxt hr_organization_information.org_information_context%type; ----Bug 7115367
2363:
2364: ln_index NUMBER;
2365: lv_exists VARCHAR2(1);
2366: lv_procedure_name VARCHAR2(100);