APPS.PAY_GB_RTI_FPS dependencies on HR_ORGANIZATION_INFORMATION

Line 7263: l_sender_id hr_organization_information.org_information11%TYPE;

7259: p_payroll_action_id IN NUMBER)
7260: IS
7261: error_found EXCEPTION;
7262: l_proc CONSTANT VARCHAR2(50) := g_package || ' archinit';
7263: l_sender_id hr_organization_information.org_information11%TYPE;
7264: l_tax_ref hr_organization_information.org_information1%TYPE;
7265: l_tax_dist hr_organization_information.org_information2%TYPE;
7266: l_employer_addr VARCHAR2(255);
7267: l_employer_name VARCHAR2(150);

Line 7264: l_tax_ref hr_organization_information.org_information1%TYPE;

7260: IS
7261: error_found EXCEPTION;
7262: l_proc CONSTANT VARCHAR2(50) := g_package || ' archinit';
7263: l_sender_id hr_organization_information.org_information11%TYPE;
7264: l_tax_ref hr_organization_information.org_information1%TYPE;
7265: l_tax_dist hr_organization_information.org_information2%TYPE;
7266: l_employer_addr VARCHAR2(255);
7267: l_employer_name VARCHAR2(150);
7268: l_err BOOLEAN;

Line 7265: l_tax_dist hr_organization_information.org_information2%TYPE;

7261: error_found EXCEPTION;
7262: l_proc CONSTANT VARCHAR2(50) := g_package || ' archinit';
7263: l_sender_id hr_organization_information.org_information11%TYPE;
7264: l_tax_ref hr_organization_information.org_information1%TYPE;
7265: l_tax_dist hr_organization_information.org_information2%TYPE;
7266: l_employer_addr VARCHAR2(255);
7267: l_employer_name VARCHAR2(150);
7268: l_err BOOLEAN;
7269: l_exp EXCEPTION;

Line 7313: hr_organization_information hoi

7309: DECODE(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,
7310: NVL(upper(SUBSTR(hoi.org_information6,1,13)),' ') acc_ref_no,
7311: report_type
7312: FROM pay_payroll_actions pact,
7313: hr_organization_information hoi
7314: WHERE pact.payroll_action_id =pactid
7315: AND pact.business_group_id = hoi.organization_id
7316: AND hoi.org_information_context = 'Tax Details References'
7317: AND NVL(hoi.org_information10,'UK') = 'UK'

Line 12377: hr_organization_information hoi

12373: pact.business_group_id bus_grp_id,
12374: pact.action_parameter_group_id act_param_grp_id,
12375: org_information19 service_company
12376: FROM pay_payroll_actions pact,
12377: hr_organization_information hoi
12378: WHERE pact.payroll_action_id =pactid
12379: AND pact.business_group_id = hoi.organization_id
12380: AND hoi.org_information_context = 'Tax Details References'
12381: AND NVL(hoi.org_information10,'UK') = 'UK'

Line 12449: FROM hr_organization_information hoi

12445: SELECT NVL(hoi.org_information11,' ') sender_id,
12446: NVL(upper(hoi.org_information2),' ') hrmc_office,
12447: NVL(upper(hoi.org_information4),' ') er_addr,
12448: NVL(upper(hoi.org_information3),' ') er_name
12449: FROM hr_organization_information hoi
12450: WHERE hoi.organization_id = p_bus_id
12451: AND hoi.org_information_context = 'Tax Details References'
12452: AND NVL(hoi.org_information10,'UK') = 'UK'
12453: AND upper(hoi.org_information1) = upper(p_tax_ref);