APPS.PAY_NO_UNION_DUES dependencies on HR_ORGANIZATION_INFORMATION

Line 120: ,hr_organization_information hoi

116:
117: cursor csr_le_details ( l_leg_emp_id NUMBER ) is
118: select hou.name ,hoi.org_information1
119: from hr_organization_units hou
120: ,hr_organization_information hoi
121: where hou.organization_id = l_leg_emp_id
122: and hoi.organization_id = l_leg_emp_id
123: and hoi.org_information_context = to_char('NO_LEGAL_EMPLOYER_DETAILS');
124:

Line 554: ,hr_organization_information hoi

550: cursor csr_third_party_dest_acc (p_organization_id NUMBER) is
551: select segment6
552: from pay_external_accounts acc
553: ,pay_org_payment_methods_f pay_org
554: ,hr_organization_information hoi
555: where hoi.organization_id = p_organization_id
556: and hoi.org_information_context = 'NO_THIRD_PARTY_PAYMENT'
557: and pay_org.org_payment_method_id = hoi.org_information2
558: and pay_org.pmeth_information1 = 'DESTINATION'

Line 721: l_orgnumber hr_organization_information.org_information1%type;

717: p_template_name in varchar2,
718: p_xml out nocopy clob) is
719:
720: l_employer hr_all_organization_units.name%type;
721: l_orgnumber hr_organization_information.org_information1%type;
722: l_from_date DATE;
723: l_to_date DATE;
724: l_thirdparty_id pay_action_information.ACTION_INFORMATION5%type:='-999';
725: l_payroll_action_id varchar2(150);