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

Line 2731: FROM hr_organization_information

2727: AND balance_name = 'Total Payments';
2728:
2729: CURSOR c_get_legislation_code (cp_business_group IN NUMBER) IS
2730: SELECT org_information9
2731: FROM hr_organization_information
2732: WHERE org_information_context = 'Business Group Information'
2733: AND organization_id = cp_business_group;
2734:
2735: CURSOR c_legislation_rule (cp_legislation_code IN VARCHAR2

Line 3194: FROM hr_organization_information hri

3190: SELECT hri.org_information1,
3191: hri.org_information2, hri.org_information3,
3192: hri.org_information4, hri.org_information5,
3193: hri.org_information6, hri.org_information7
3194: FROM hr_organization_information hri
3195: WHERE hri.organization_id = cp_organization_id
3196: AND hri.org_information_context = cp_org_information_context
3197: AND hri.org_information1 = 'MESG';
3198:

Line 3199: lv_org_information1 hr_organization_information.org_information1%TYPE;

3195: WHERE hri.organization_id = cp_organization_id
3196: AND hri.org_information_context = cp_org_information_context
3197: AND hri.org_information1 = 'MESG';
3198:
3199: lv_org_information1 hr_organization_information.org_information1%TYPE;
3200: lv_org_information2 hr_organization_information.org_information2%TYPE;
3201: lv_org_information3 hr_organization_information.org_information3%TYPE;
3202: lv_org_information4 hr_organization_information.org_information4%TYPE;
3203: lv_org_information5 hr_organization_information.org_information5%TYPE;

Line 3200: lv_org_information2 hr_organization_information.org_information2%TYPE;

3196: AND hri.org_information_context = cp_org_information_context
3197: AND hri.org_information1 = 'MESG';
3198:
3199: lv_org_information1 hr_organization_information.org_information1%TYPE;
3200: lv_org_information2 hr_organization_information.org_information2%TYPE;
3201: lv_org_information3 hr_organization_information.org_information3%TYPE;
3202: lv_org_information4 hr_organization_information.org_information4%TYPE;
3203: lv_org_information5 hr_organization_information.org_information5%TYPE;
3204: lv_org_information6 hr_organization_information.org_information6%TYPE;

Line 3201: lv_org_information3 hr_organization_information.org_information3%TYPE;

3197: AND hri.org_information1 = 'MESG';
3198:
3199: lv_org_information1 hr_organization_information.org_information1%TYPE;
3200: lv_org_information2 hr_organization_information.org_information2%TYPE;
3201: lv_org_information3 hr_organization_information.org_information3%TYPE;
3202: lv_org_information4 hr_organization_information.org_information4%TYPE;
3203: lv_org_information5 hr_organization_information.org_information5%TYPE;
3204: lv_org_information6 hr_organization_information.org_information6%TYPE;
3205: lv_org_information7 hr_organization_information.org_information7%TYPE;

Line 3202: lv_org_information4 hr_organization_information.org_information4%TYPE;

3198:
3199: lv_org_information1 hr_organization_information.org_information1%TYPE;
3200: lv_org_information2 hr_organization_information.org_information2%TYPE;
3201: lv_org_information3 hr_organization_information.org_information3%TYPE;
3202: lv_org_information4 hr_organization_information.org_information4%TYPE;
3203: lv_org_information5 hr_organization_information.org_information5%TYPE;
3204: lv_org_information6 hr_organization_information.org_information6%TYPE;
3205: lv_org_information7 hr_organization_information.org_information7%TYPE;
3206:

Line 3203: lv_org_information5 hr_organization_information.org_information5%TYPE;

3199: lv_org_information1 hr_organization_information.org_information1%TYPE;
3200: lv_org_information2 hr_organization_information.org_information2%TYPE;
3201: lv_org_information3 hr_organization_information.org_information3%TYPE;
3202: lv_org_information4 hr_organization_information.org_information4%TYPE;
3203: lv_org_information5 hr_organization_information.org_information5%TYPE;
3204: lv_org_information6 hr_organization_information.org_information6%TYPE;
3205: lv_org_information7 hr_organization_information.org_information7%TYPE;
3206:
3207: ln_index NUMBER;

Line 3204: lv_org_information6 hr_organization_information.org_information6%TYPE;

3200: lv_org_information2 hr_organization_information.org_information2%TYPE;
3201: lv_org_information3 hr_organization_information.org_information3%TYPE;
3202: lv_org_information4 hr_organization_information.org_information4%TYPE;
3203: lv_org_information5 hr_organization_information.org_information5%TYPE;
3204: lv_org_information6 hr_organization_information.org_information6%TYPE;
3205: lv_org_information7 hr_organization_information.org_information7%TYPE;
3206:
3207: ln_index NUMBER;
3208: lv_procedure_name VARCHAR2(100);

Line 3205: lv_org_information7 hr_organization_information.org_information7%TYPE;

3201: lv_org_information3 hr_organization_information.org_information3%TYPE;
3202: lv_org_information4 hr_organization_information.org_information4%TYPE;
3203: lv_org_information5 hr_organization_information.org_information5%TYPE;
3204: lv_org_information6 hr_organization_information.org_information6%TYPE;
3205: lv_org_information7 hr_organization_information.org_information7%TYPE;
3206:
3207: ln_index NUMBER;
3208: lv_procedure_name VARCHAR2(100);
3209:

Line 3737: hr_organization_information

3733:
3734: CURSOR c_get_archive_ytd_flag(cp_business_group_id IN NUMBER,
3735: cp_legislation_code IN VARCHAR2) is
3736: SELECT nvl(ORG_INFORMATION1,'N') FROM
3737: hr_organization_information
3738: WHERE organization_id = cp_business_group_id
3739: AND ORG_INFORMATION_CONTEXT = cp_legislation_code||'_REPORTING_PREFERENCES';
3740:
3741: CURSOR c_get_archive_absences_aaid(cp_action_id IN NUMBER) IS