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 557: ,hr_organization_information hoi

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

Line 724: l_orgnumber hr_organization_information.org_information1%type;

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

Line 957: FROM hr_organization_information

953: p_global_value := 0;
954: BEGIN
955: SELECT org_information5
956: INTO p_global_id
957: FROM hr_organization_information
958: WHERE org_information_context = 'NO_THIRD_PARTY_PAYMENT'
959: AND organization_id = p_organization_id;
960: IF p_global_id is null then
961: p_exists := 0;