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

Line 280: FROM hr_organization_information_v org

276: org.org_information3,
277: org.org_information4,
278: org.org_information5,
279: org.org_information6
280: FROM hr_organization_information_v org
281: WHERE org.org_information_context = p_context
282: AND org.organization_id = p_bg_id;
283:
284: CURSOR csr_balance_name(p_balance_type_id NUMBER,

Line 988: hr_organization_information org

984: SELECT org.organization_id
985: FROM
986: pay_all_payrolls_f ppf,
987: hr_soft_coding_keyflex flex,
988: hr_organization_information org
989: WHERE ppf.soft_coding_keyflex_id=flex.soft_coding_keyflex_id
990: AND ppf.business_group_id =p_business_group_id
991: AND org.org_information_context = 'IE_EMPLOYER_INFO'
992: AND org.organization_id=flex.segment4

Line 1947: hr_organization_information org

1943: SELECT org.org_information2
1944: FROM
1945: pay_all_payrolls_f ppf,
1946: hr_soft_coding_keyflex flex,
1947: hr_organization_information org
1948: WHERE ppf.soft_coding_keyflex_id=flex.soft_coding_keyflex_id
1949: AND ppf.business_group_id =p_business_group_id
1950: AND org.org_information_context = 'IE_EMPLOYER_INFO'
1951: AND org.organization_id=flex.segment4

Line 1957: l_paye_ref hr_organization_information.org_information2%type;

1953: AND ppf.payroll_id=p_payroll_id
1954: AND ppf.effective_start_date <= p_end_date
1955: AND ppf.effective_end_date >= p_start_date;
1956:
1957: l_paye_ref hr_organization_information.org_information2%type;
1958: l_paye_value hr_organization_information.org_information2%type;
1959: l_payroll_action_message varchar2(1000);
1960: c_error exception;
1961: error_message boolean;

Line 1958: l_paye_value hr_organization_information.org_information2%type;

1954: AND ppf.effective_start_date <= p_end_date
1955: AND ppf.effective_end_date >= p_start_date;
1956:
1957: l_paye_ref hr_organization_information.org_information2%type;
1958: l_paye_value hr_organization_information.org_information2%type;
1959: l_payroll_action_message varchar2(1000);
1960: c_error exception;
1961: error_message boolean;
1962: l_proc CONSTANT VARCHAR2(100):= g_package||'get_paye_reference_details';

Line 2056: hr_organization_information org

2052: pact.pay_advice_message payroll_message
2053: FROM pay_payrolls_f ppf,
2054: pay_payroll_actions pact,
2055: hr_soft_coding_keyflex flex,
2056: hr_organization_information org
2057: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
2058: AND org.org_information_context = 'IE_ORG_INFORMATION'
2059: AND org.org_information1 = flex.segment1
2060: AND ppf.business_group_id = org.organization_id

Line 2085: , g_paye_ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%type

2081:
2082:
2083: -- cursor csr_get_org_tax_address
2084: CURSOR csr_get_org_tax_address( c_consolidation_set PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_ID%type
2085: , g_paye_ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%type
2086: ) IS
2087: SELECT org_info.org_information3 employer_tax_addr1
2088: ,org_info.org_information4 employer_tax_addr2
2089: ,org_info.org_information5 employer_tax_addr3

Line 2098: ,hr_organization_information org_info

2094: ,org_info.org_information8 employer_tax_rep_name
2095: ,pcs.business_group_id business_group_id
2096: --
2097: FROM hr_all_organization_units org_all
2098: ,hr_organization_information org_info
2099: ,pay_consolidation_sets pcs
2100: WHERE pcs.consolidation_set_id = c_consolidation_set
2101: AND org_all.organization_id = pcs.business_group_id
2102: AND org_info.organization_id = org_all.organization_id

Line 3193: hr_organization_information org

3189: pact.pay_advice_message payroll_message
3190: FROM pay_payrolls_f ppf,
3191: pay_payroll_actions pact,
3192: hr_soft_coding_keyflex flex,
3193: hr_organization_information org
3194: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
3195: AND org.org_information_context = 'IE_EMPLOYER_INFO'
3196: AND org.organization_id = flex.segment4
3197: -- AND ppf.business_group_id = org.organization_id

Line 3228: , g_paye_ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%type

3224:
3225:
3226: -- cursor csr_get_org_tax_address
3227: CURSOR csr_get_org_tax_address( c_consolidation_set PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_ID%type
3228: , g_paye_ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%type
3229: ) IS
3230: SELECT hrl.address_line_1 employer_tax_addr1
3231: ,hrl.address_line_2 employer_tax_addr2
3232: ,hrl.address_line_3 employer_tax_addr3

Line 3241: ,hr_organization_information org_info

3237: ,org_all.name employer_tax_rep_name
3238: ,pcs.business_group_id business_group_id
3239: --
3240: FROM hr_all_organization_units org_all
3241: ,hr_organization_information org_info
3242: ,pay_consolidation_sets pcs
3243: ,hr_locations_all hrl
3244: WHERE pcs.consolidation_set_id = c_consolidation_set
3245: AND org_all.business_group_id = pcs.business_group_id