APPS.PAY_CA_PAYROLL_ARCH dependencies on HR_ORGANIZATION_INFORMATION

Line 278: from hr_organization_information hoi

274: p_asg_act_id in number)
275: RETURN number is
276: cursor cur_taxgrp is
277: select org_information4
278: from hr_organization_information hoi
279: where hoi.org_information_context = 'Canada Employer Identification'
280: and hoi.organization_id = p_tax_unit_id;
281:
282: ln_taxgrp_gre_id number;

Line 757: from hr_organization_information hoi

753: and ppf.effective_end_date;
754:
755: cursor cur_taxgrp is
756: select org_information4
757: from hr_organization_information hoi
758: where hoi.org_information_context = 'Canada Employer Identification'
759: and hoi.organization_id = p_tax_unit_id;
760:
761: cursor cur_get_base_lang is

Line 2463: from hr_organization_information

2459: where paa.assignment_action_id = cp_assignment_action;
2460:
2461: cursor c_legislation (cp_business_group in number) is
2462: select org_information9
2463: from hr_organization_information
2464: where org_information_context = 'Business Group Information'
2465: and organization_id = cp_business_group;
2466:
2467: cursor c_sepchk_run_type is

Line 3438: from hr_organization_information hoi,

3434: PROCEDURE py_archinit(p_payroll_action_id in number) is
3435:
3436: cursor cur_reporting_level(p_pactid in number) is
3437: select org_information1
3438: from hr_organization_information hoi,
3439: pay_payroll_actions ppa
3440: where ppa.payroll_action_id = p_pactid
3441: and hoi.organization_id = ppa.business_group_id
3442: and hoi.org_information_context = 'Payroll Archiver Level';