APPS.PAY_GB_EOY_MAGTAPE dependencies on HR_ORGANIZATION_INFORMATION

Line 721: -- Get the EDI sender id from hr_organization_information

717: RETURN p_formula_id;
718: END;
719: --
720: PROCEDURE get_edi_sender_id(p_payroll_action_id IN NUMBER) IS
721: -- Get the EDI sender id from hr_organization_information
722: l_edi_sender_id VARCHAR2(35) := ' ';
723: CURSOR sender_id_cur IS
724: SELECT upper(nvl(org_information11,' ')) edi_sender_id,
725: pact.request_id

Line 727: hr_organization_information hoi

723: CURSOR sender_id_cur IS
724: SELECT upper(nvl(org_information11,' ')) edi_sender_id,
725: pact.request_id
726: FROM pay_payroll_actions pact,
727: hr_organization_information hoi
728: WHERE pact.payroll_action_id = p_payroll_action_id
729: AND hoi.org_information_context = 'Tax Details References'
730: AND hoi.org_information1 = g_tax_district_ref||'/'||g_tax_ref_no
731: AND hoi.organization_id = pact.business_group_id;

Line 742: -- Get the EDI sender id from hr_organization_information

738: -- Bug 2696015: Added for P14 EDI 2003 Enhancement
739:
740: /* Start 4011263
741: PROCEDURE get_edi_submitter_no(p_payroll_action_id IN NUMBER) IS
742: -- Get the EDI sender id from hr_organization_information
743: edi_submitter_no VARCHAR2(10) := ' ';
744: CURSOR cur_sumbmitter_no IS
745: SELECT nvl(org_information13,' ') edi_submitter_no
746: FROM pay_payroll_actions pact,

Line 747: hr_organization_information hoi

743: edi_submitter_no VARCHAR2(10) := ' ';
744: CURSOR cur_sumbmitter_no IS
745: SELECT nvl(org_information13,' ') edi_submitter_no
746: FROM pay_payroll_actions pact,
747: hr_organization_information hoi
748: WHERE pact.payroll_action_id = p_payroll_action_id
749: AND hoi.org_information_context = 'Tax Details References'
750: AND hoi.org_information1 = g_tax_district_ref||'/'||g_tax_ref_no
751: AND hoi.organization_id = pact.business_group_id;