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

Line 1171: hr_organization_information hoi

1167: begin
1168: select hou.name
1169: into lv_tax_group
1170: from hr_all_organization_units hou,
1171: hr_organization_information hoi
1172: where hou.organization_id = hoi.organization_id
1173: and hoi.org_information_context = 'CLASS'
1174: and hoi.org_information1 = 'CA_TAX_GROUP'
1175: and hou.business_group_id = p_business_group_id

Line 1194: from hr_organization_information hoi1,

1190: if p_quebec = 'Y' then
1191: begin
1192: select pcp.account_number
1193: into lv_account_number
1194: from hr_organization_information hoi1,
1195: hr_organization_information hoi2,
1196: pay_ca_pmed_accounts pcp
1197: where hoi1.org_information_context = 'CLASS'
1198: and hoi1.org_information1 = 'CA_PMED'

Line 1195: hr_organization_information hoi2,

1191: begin
1192: select pcp.account_number
1193: into lv_account_number
1194: from hr_organization_information hoi1,
1195: hr_organization_information hoi2,
1196: pay_ca_pmed_accounts pcp
1197: where hoi1.org_information_context = 'CLASS'
1198: and hoi1.org_information1 = 'CA_PMED'
1199: and hoi1.org_information2 = 'Y'

Line 2418: from hr_organization_information

2414: -- get the GRE contact
2415:
2416: cursor c_gre_contact is
2417: select org_information1
2418: from hr_organization_information
2419: where org_information_context || '' = 'Contact Information'
2420: and organization_id = p_gre_id;
2421:
2422: begin