APPS.PAY_CA_PAYROLL_ARCH dependencies on HR_ORGANIZATION_INFORMATION

Line 292: from hr_organization_information hoi

288: p_asg_act_id in number)
289: RETURN number is
290: cursor cur_taxgrp is
291: select org_information4
292: from hr_organization_information hoi
293: where hoi.org_information_context = 'Canada Employer Identification'
294: and hoi.organization_id = p_tax_unit_id;
295:
296: ln_taxgrp_gre_id number;

Line 804: from hr_organization_information

800: and loc.location_id(+) = hou.location_id;
801:
802: cursor c_legislation (cp_business_group_id in number) is
803: select org_information9
804: from hr_organization_information
805: where org_information_context = 'Business Group Information'
806: and organization_id = cp_business_group_id;
807:
808: cursor att_no (cp_pre_payment_id in number

Line 1225: from hr_organization_information hoi

1221: and ppf.effective_end_date;
1222:
1223: cursor cur_taxgrp is
1224: select org_information4
1225: from hr_organization_information hoi
1226: where hoi.org_information_context = 'Canada Employer Identification'
1227: and hoi.organization_id = p_tax_unit_id;
1228:
1229: -- added for 13029997

Line 2974: from hr_organization_information

2970: where paa.assignment_action_id = cp_assignment_action;
2971:
2972: cursor c_legislation (cp_business_group in number) is
2973: select org_information9
2974: from hr_organization_information
2975: where org_information_context = 'Business Group Information'
2976: and organization_id = cp_business_group;
2977:
2978: cursor c_sepchk_run_type is

Line 3949: from hr_organization_information hoi,

3945: PROCEDURE py_archinit(p_payroll_action_id in number) is
3946:
3947: cursor cur_reporting_level(p_pactid in number) is
3948: select org_information1
3949: from hr_organization_information hoi,
3950: pay_payroll_actions ppa
3951: where ppa.payroll_action_id = p_pactid
3952: and hoi.organization_id = ppa.business_group_id
3953: and hoi.org_information_context = 'Payroll Archiver Level';