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 982: from hr_organization_information hoi,

978:
979: cursor c_trans_payid ( c_trans_id VARCHAR2,
980: c_year VARCHAR2) is
981: Select ppa.payroll_action_id, ppa.business_group_id
982: from hr_organization_information hoi,
983: pay_payroll_actions PPA,
984: pay_ca_legislation_info pcli,
985: pay_ca_legislation_info pcli1
986: where hoi.organization_id = to_number(c_trans_id)

Line 1002: hr_organization_information hoi,

998: p_year VARCHAR2,
999: p_bg_id NUMBER) is
1000: Select distinct ppa.payroll_action_id, hoi.organization_id, hou.name
1001: From pay_payroll_actions ppa,
1002: hr_organization_information hoi,
1003: hr_all_organization_units hou
1004: where hoi.org_information_context = 'Canada Employer Identification'
1005: and hoi.org_information11 = p_trans
1006: and hou.business_group_id = p_bg_id