APPS.PAY_NO_TAX_LEVY dependencies on HR_ORGANIZATION_INFORMATION

Line 114: from hr_organization_information hoi

110:
111:
112: cursor csr_org_number ( l_leg_emp_id NUMBER ) is
113: select hoi.org_information1
114: from hr_organization_information hoi
115: where hoi.organization_id = l_leg_emp_id
116: and hoi.org_information_context = to_char('NO_LEGAL_EMPLOYER_DETAILS');
117:
118:

Line 564: ,hr_organization_information hoi

560: cursor csr_third_party_dest_acc (p_organization_id NUMBER) is
561: select segment6
562: from pay_external_accounts acc
563: ,pay_org_payment_methods_f pay_org
564: ,hr_organization_information hoi
565: where hoi.organization_id = p_organization_id
566: and hoi.org_information_context = 'NO_THIRD_PARTY_PAYMENT'
567: and pay_org.org_payment_method_id = hoi.org_information2
568: and pay_org.pmeth_information1 = 'DESTINATION'

Line 726: l_orgnumber hr_organization_information.org_information1%type;

722: p_template_name in varchar2,
723: p_xml out nocopy clob) is
724:
725: l_employer hr_all_organization_units.name%type;
726: l_orgnumber hr_organization_information.org_information1%type;
727: l_term varchar2(30);
728: l_year varchar2(8);
729: l_thirdparty_id pay_action_information.ACTION_INFORMATION5%type:='-999';
730: l_payroll_action_id varchar2(150);