APPS.PAY_CA_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 370: hr_organization_information hoi

366: select
367: hoi.org_information2
368: from
369: hr_organization_units hou,
370: hr_organization_information hoi
371: where
372: hou.business_group_id = p_business_group_id and
373: hou.organization_id = hoi.organization_id and
374: hoi.org_information_context = 'Canadian Work Schedule';

Line 920: hr_organization_information hoi

916: 'T4' gre_type
917: from
918: pay_assignment_actions paa,
919: pay_payroll_actions ppa,
920: hr_organization_information hoi
921: where
922: paa.assignment_id = p_assignment_id and
923: ppa.payroll_action_id = paa.payroll_action_id and
924: ppa.payroll_id = p_payroll_id and

Line 939: hr_organization_information hoi

935: 'T4A' gre_type
936: from
937: pay_assignment_actions paa,
938: pay_payroll_actions ppa,
939: hr_organization_information hoi
940: where
941: paa.assignment_id = p_assignment_id and
942: ppa.payroll_action_id = paa.payroll_action_id and
943: ppa.payroll_id = p_payroll_id and

Line 956: hr_organization_information hoi_t4

952: (select 1
953: from
954: pay_assignment_actions paa_t4,
955: pay_payroll_actions ppa_t4,
956: hr_organization_information hoi_t4
957: where
958: paa_t4.assignment_id = p_assignment_id and
959: ppa_t4.payroll_action_id = paa_t4.payroll_action_id and
960: ppa_t4.payroll_id = p_payroll_id and

Line 1797: hr_organization_information hoi

1793: hctu.country country,
1794: hctu.postal_code postal_code,
1795: hctu.telephone_number_1 telephone
1796: from hr_ca_tax_units_v hctu,
1797: hr_organization_information hoi
1798: where hctu.tax_unit_id=l_tax_unit_id
1799: and hoi.organization_id = l_tax_unit_id
1800: and hoi.org_information_context = 'Canada Employer Identification';
1801:

Line 1912: from hr_organization_information hoi

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

Line 2137: l_tax_group_id hr_organization_information.org_information4%TYPE;

2133: l_temp_value3 number := 0;
2134: l_temp_code3 varchar2(1);
2135: l_term_or_abs_flag varchar2(1);
2136: l_term_or_abs varchar2(1);
2137: l_tax_group_id hr_organization_information.org_information4%TYPE;
2138: l_t4a_gre varchar2(1);
2139:
2140: cursor cur_tax_group is
2141: select

Line 2144: hr_organization_information

2140: cursor cur_tax_group is
2141: select
2142: org_information4
2143: from
2144: hr_organization_information
2145: where
2146: organization_id = l_tax_unit_id and
2147: org_information_context = 'Canada Employer Identification';
2148:

Line 2153: hr_organization_information

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