APPS.PAY_CA_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 374: hr_organization_information hoi

370: select
371: hoi.org_information2
372: from
373: hr_organization_units hou,
374: hr_organization_information hoi
375: where
376: hou.business_group_id = p_business_group_id and
377: hou.organization_id = hoi.organization_id and
378: hoi.org_information_context = 'Canadian Work Schedule';

Line 924: hr_organization_information hoi

920: 'T4' gre_type
921: from
922: pay_assignment_actions paa,
923: pay_payroll_actions ppa,
924: hr_organization_information hoi
925: where
926: paa.assignment_id = p_assignment_id and
927: ppa.payroll_action_id = paa.payroll_action_id and
928: ppa.payroll_id = p_payroll_id and

Line 943: hr_organization_information hoi

939: 'T4A' gre_type
940: from
941: pay_assignment_actions paa,
942: pay_payroll_actions ppa,
943: hr_organization_information hoi
944: where
945: paa.assignment_id = p_assignment_id and
946: ppa.payroll_action_id = paa.payroll_action_id and
947: ppa.payroll_id = p_payroll_id and

Line 960: hr_organization_information hoi_t4

956: (select 1
957: from
958: pay_assignment_actions paa_t4,
959: pay_payroll_actions ppa_t4,
960: hr_organization_information hoi_t4
961: where
962: paa_t4.assignment_id = p_assignment_id and
963: ppa_t4.payroll_action_id = paa_t4.payroll_action_id and
964: ppa_t4.payroll_id = p_payroll_id and

Line 1801: hr_organization_information hoi

1797: hctu.country country,
1798: hctu.postal_code postal_code,
1799: hctu.telephone_number_1 telephone
1800: from hr_ca_tax_units_v hctu,
1801: hr_organization_information hoi
1802: where hctu.tax_unit_id=l_tax_unit_id
1803: and hoi.organization_id = l_tax_unit_id
1804: and hoi.org_information_context = 'Canada Employer Identification';
1805:

Line 1916: from hr_organization_information hoi

1912: --
1913: --
1914: cursor cur_business_number(l_tax_unit_id number ) is
1915: select hoi.org_information1 business_number
1916: from hr_organization_information hoi
1917: where l_tax_unit_id = hoi.organization_id
1918: and ltrim(rtrim(hoi.org_information_context)) =
1919: 'Canada Employer Identification';
1920:

Line 2141: l_tax_group_id hr_organization_information.org_information4%TYPE;

2137: l_temp_value3 number := 0;
2138: l_temp_code3 varchar2(1);
2139: l_term_or_abs_flag varchar2(1);
2140: l_term_or_abs varchar2(1);
2141: l_tax_group_id hr_organization_information.org_information4%TYPE;
2142: l_t4a_gre varchar2(1);
2143:
2144: cursor cur_tax_group is
2145: select

Line 2148: hr_organization_information

2144: cursor cur_tax_group is
2145: select
2146: org_information4
2147: from
2148: hr_organization_information
2149: where
2150: organization_id = l_tax_unit_id and
2151: org_information_context = 'Canada Employer Identification';
2152:

Line 2157: hr_organization_information

2153: cursor cur_17_gres(p_tax_group_id varchar2) is
2154: select
2155: organization_id tax_unit_id
2156: from
2157: hr_organization_information
2158: where
2159: org_information4 = p_tax_group_id and
2160: org_information_context = 'Canada Employer Identification' and
2161: org_information5 in ('T4A/RL1','T4A/RL2') and