APPS.PAY_CA_T4_MAG dependencies on HR_ORGANIZATION_INFORMATION

Line 169: hr_organization_information hoi1,

165: AND paa.action_status = 'C'
166: AND exists ( /* Query to select all GRE 's under a transmitter GRE */
167: select 'X'
168: from
169: hr_organization_information hoi1,
170: hr_organization_information hoi
171: where hoi.organization_id = paa.tax_unit_id
172: and hoi.org_information_context = 'Canada Employer Identification'
173: and to_number(hoi.org_information11) = pay_ca_t4_mag.get_parameter('TRANSMITTER_GRE',ppa1.legislative_parameters)

Line 170: hr_organization_information hoi

166: AND exists ( /* Query to select all GRE 's under a transmitter GRE */
167: select 'X'
168: from
169: hr_organization_information hoi1,
170: hr_organization_information hoi
171: where hoi.organization_id = paa.tax_unit_id
172: and hoi.org_information_context = 'Canada Employer Identification'
173: and to_number(hoi.org_information11) = pay_ca_t4_mag.get_parameter('TRANSMITTER_GRE',ppa1.legislative_parameters)
174: and hoi1.org_information_context = 'Fed Magnetic Reporting'

Line 786: from hr_organization_information hoi,

782:
783: cursor c_trans_payid ( c_trans_id VARCHAR2,
784: c_year VARCHAR2) is
785: Select ppa.payroll_action_id, ppa.business_group_id
786: from hr_organization_information hoi,
787: pay_payroll_actions PPA,
788: pay_ca_legislation_info pcli,
789: pay_ca_legislation_info pcli1
790: where hoi.organization_id = to_number(c_trans_id)

Line 806: hr_organization_information hoi,

802: p_year VARCHAR2,
803: p_bg_id NUMBER) is
804: Select distinct ppa.payroll_action_id, hoi.organization_id, hou.name
805: From pay_payroll_actions ppa,
806: hr_organization_information hoi,
807: hr_all_organization_units hou
808: where hoi.org_information_context = 'Canada Employer Identification'
809: and hoi.org_information11 = p_trans
810: and hou.business_group_id = p_bg_id