APPS.PAY_GB_EOY_MAGTAPE dependencies on HR_ORGANIZATION_INFORMATION

Line 799: hr_organization_information org

795: distinct asg.assignment_id, asg.effective_start_date, asg.effective_end_date
796: FROM per_all_assignments_f asg,
797: pay_all_payrolls_f ppf,
798: hr_soft_coding_keyflex flex,
799: hr_organization_information org
800: WHERE asg.person_id = p_person_id
801: AND asg.effective_end_date >= p_min_start_year_date
802: AND asg.effective_start_date <= p_max_end_year_date
803: AND asg.payroll_id = ppf.payroll_id

Line 827: hr_organization_information org

823: distinct asg.assignment_id, asg.effective_start_date, asg.effective_end_date
824: FROM per_all_assignments_f asg,
825: pay_all_payrolls_f ppf,
826: hr_soft_coding_keyflex flex,
827: hr_organization_information org
828: WHERE asg.person_id = p_person_id
829: AND asg.effective_end_date >= p_min_start_year_date
830: AND asg.effective_start_date <= p_max_end_year_date
831: AND asg.payroll_id = ppf.payroll_id

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

879: RETURN p_formula_id;
880: END;
881: --
882: PROCEDURE get_edi_sender_id(p_payroll_action_id IN NUMBER) IS
883: -- Get the EDI sender id from hr_organization_information
884: l_edi_sender_id VARCHAR2(35) := ' ';
885: CURSOR sender_id_cur IS
886: SELECT upper(nvl(org_information11,' ')) edi_sender_id,
887: pact.request_id

Line 889: hr_organization_information hoi

885: CURSOR sender_id_cur IS
886: SELECT upper(nvl(org_information11,' ')) edi_sender_id,
887: pact.request_id
888: FROM pay_payroll_actions pact,
889: hr_organization_information hoi
890: WHERE pact.payroll_action_id = p_payroll_action_id
891: AND hoi.org_information_context = 'Tax Details References'
892: AND hoi.org_information1 = g_tax_district_ref||'/'||g_tax_ref_no
893: AND hoi.organization_id = pact.business_group_id;

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

900: -- Bug 2696015: Added for P14 EDI 2003 Enhancement
901:
902: /* Start 4011263
903: PROCEDURE get_edi_submitter_no(p_payroll_action_id IN NUMBER) IS
904: -- Get the EDI sender id from hr_organization_information
905: edi_submitter_no VARCHAR2(10) := ' ';
906: CURSOR cur_sumbmitter_no IS
907: SELECT nvl(org_information13,' ') edi_submitter_no
908: FROM pay_payroll_actions pact,

Line 909: hr_organization_information hoi

905: edi_submitter_no VARCHAR2(10) := ' ';
906: CURSOR cur_sumbmitter_no IS
907: SELECT nvl(org_information13,' ') edi_submitter_no
908: FROM pay_payroll_actions pact,
909: hr_organization_information hoi
910: WHERE pact.payroll_action_id = p_payroll_action_id
911: AND hoi.org_information_context = 'Tax Details References'
912: AND hoi.org_information1 = g_tax_district_ref||'/'||g_tax_ref_no
913: AND hoi.organization_id = pact.business_group_id;