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 126: FROM hr_organization_information_v org

122: org.org_information3,
123: org.org_information4,
124: org.org_information5,
125: org.org_information6
126: FROM hr_organization_information_v org
127: WHERE org.org_information_context = p_context
128: AND org.organization_id = p_bg_id;
129:
130: CURSOR csr_balance_name(p_balance_type_id NUMBER,

Line 799: hr_organization_information org

795: SELECT org.organization_id
796: FROM
797: pay_all_payrolls_f ppf,
798: hr_soft_coding_keyflex flex,
799: hr_organization_information org
800: WHERE ppf.soft_coding_keyflex_id=flex.soft_coding_keyflex_id
801: AND ppf.business_group_id =p_business_group_id
802: AND org.org_information_context = 'IE_EMPLOYER_INFO'
803: AND org.organization_id=flex.segment4

Line 1660: hr_organization_information org

1656: SELECT org.org_information2
1657: FROM
1658: pay_all_payrolls_f ppf,
1659: hr_soft_coding_keyflex flex,
1660: hr_organization_information org
1661: WHERE ppf.soft_coding_keyflex_id=flex.soft_coding_keyflex_id
1662: AND ppf.business_group_id =p_business_group_id
1663: AND org.org_information_context = 'IE_EMPLOYER_INFO'
1664: AND org.organization_id=flex.segment4

Line 1670: l_paye_ref hr_organization_information.org_information2%type;

1666: AND ppf.payroll_id=p_payroll_id
1667: AND ppf.effective_start_date <= p_end_date
1668: AND ppf.effective_end_date >= p_start_date;
1669:
1670: l_paye_ref hr_organization_information.org_information2%type;
1671: l_paye_value hr_organization_information.org_information2%type;
1672: l_payroll_action_message varchar2(1000);
1673: c_error exception;
1674: error_message boolean;

Line 1671: l_paye_value hr_organization_information.org_information2%type;

1667: AND ppf.effective_start_date <= p_end_date
1668: AND ppf.effective_end_date >= p_start_date;
1669:
1670: l_paye_ref hr_organization_information.org_information2%type;
1671: l_paye_value hr_organization_information.org_information2%type;
1672: l_payroll_action_message varchar2(1000);
1673: c_error exception;
1674: error_message boolean;
1675: l_proc CONSTANT VARCHAR2(100):= g_package||'get_paye_reference_details';

Line 1769: hr_organization_information org

1765: pact.pay_advice_message payroll_message
1766: FROM pay_payrolls_f ppf,
1767: pay_payroll_actions pact,
1768: hr_soft_coding_keyflex flex,
1769: hr_organization_information org
1770: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
1771: AND org.org_information_context = 'IE_ORG_INFORMATION'
1772: AND org.org_information1 = flex.segment1
1773: AND ppf.business_group_id = org.organization_id

Line 1798: , g_paye_ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%type

1794:
1795:
1796: -- cursor csr_get_org_tax_address
1797: CURSOR csr_get_org_tax_address( c_consolidation_set PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_ID%type
1798: , g_paye_ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%type
1799: ) IS
1800: SELECT org_info.org_information3 employer_tax_addr1
1801: ,org_info.org_information4 employer_tax_addr2
1802: ,org_info.org_information5 employer_tax_addr3

Line 1811: ,hr_organization_information org_info

1807: ,org_info.org_information8 employer_tax_rep_name
1808: ,pcs.business_group_id business_group_id
1809: --
1810: FROM hr_all_organization_units org_all
1811: ,hr_organization_information org_info
1812: ,pay_consolidation_sets pcs
1813: WHERE pcs.consolidation_set_id = c_consolidation_set
1814: AND org_all.organization_id = pcs.business_group_id
1815: AND org_info.organization_id = org_all.organization_id

Line 2878: hr_organization_information org

2874: pact.pay_advice_message payroll_message
2875: FROM pay_payrolls_f ppf,
2876: pay_payroll_actions pact,
2877: hr_soft_coding_keyflex flex,
2878: hr_organization_information org
2879: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
2880: AND org.org_information_context = 'IE_EMPLOYER_INFO'
2881: AND org.organization_id = flex.segment4
2882: -- AND ppf.business_group_id = org.organization_id

Line 2913: , g_paye_ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%type

2909:
2910:
2911: -- cursor csr_get_org_tax_address
2912: CURSOR csr_get_org_tax_address( c_consolidation_set PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_ID%type
2913: , g_paye_ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%type
2914: ) IS
2915: SELECT hrl.address_line_1 employer_tax_addr1
2916: ,hrl.address_line_2 employer_tax_addr2
2917: ,hrl.address_line_3 employer_tax_addr3

Line 2926: ,hr_organization_information org_info

2922: ,org_all.name employer_tax_rep_name
2923: ,pcs.business_group_id business_group_id
2924: --
2925: FROM hr_all_organization_units org_all
2926: ,hr_organization_information org_info
2927: ,pay_consolidation_sets pcs
2928: ,hr_locations_all hrl
2929: WHERE pcs.consolidation_set_id = c_consolidation_set
2930: AND org_all.business_group_id = pcs.business_group_id