APPS.PAY_GB_RTI dependencies on HR_ORGANIZATION_INFORMATION

Line 2213: l_sender_id hr_organization_information.org_information11%TYPE;

2209: PROCEDURE archinit(p_payroll_action_id IN NUMBER)
2210: IS
2211: l_proc CONSTANT VARCHAR2(50) := g_package || ' archinit';
2212:
2213: l_sender_id hr_organization_information.org_information11%TYPE;
2214: l_tax_ref hr_organization_information.org_information1%TYPE;
2215: l_tax_dist hr_organization_information.org_information2%TYPE;
2216:
2217: l_employer_addr VARCHAR2(255);

Line 2214: l_tax_ref hr_organization_information.org_information1%TYPE;

2210: IS
2211: l_proc CONSTANT VARCHAR2(50) := g_package || ' archinit';
2212:
2213: l_sender_id hr_organization_information.org_information11%TYPE;
2214: l_tax_ref hr_organization_information.org_information1%TYPE;
2215: l_tax_dist hr_organization_information.org_information2%TYPE;
2216:
2217: l_employer_addr VARCHAR2(255);
2218: l_employer_name VARCHAR2(150);

Line 2215: l_tax_dist hr_organization_information.org_information2%TYPE;

2211: l_proc CONSTANT VARCHAR2(50) := g_package || ' archinit';
2212:
2213: l_sender_id hr_organization_information.org_information11%TYPE;
2214: l_tax_ref hr_organization_information.org_information1%TYPE;
2215: l_tax_dist hr_organization_information.org_information2%TYPE;
2216:
2217: l_employer_addr VARCHAR2(255);
2218: l_employer_name VARCHAR2(150);
2219: l_err BOOLEAN;

Line 2235: hr_organization_information hoi

2231: decode(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,
2232: nvl(upper(substr(hoi.org_information6,1,13)),' ') acc_ref_no,
2233: report_type
2234: from pay_payroll_actions pact,
2235: hr_organization_information hoi
2236: where pact.payroll_action_id=pactid
2237: and pact.business_group_id = hoi.organization_id
2238: and hoi.org_information_context = 'Tax Details References'
2239: and nvl(hoi.org_information10,'UK') = 'UK'

Line 2547: hr_organization_information hoi

2543:
2544: pact.business_group_id bus_grp_id,
2545: pact.action_parameter_group_id act_param_grp_id
2546: from pay_payroll_actions pact,
2547: hr_organization_information hoi
2548: where pact.payroll_action_id=pactid
2549: and pact.business_group_id = hoi.organization_id
2550: and hoi.org_information_context = 'Tax Details References'
2551: and nvl(hoi.org_information10,'UK') = 'UK'

Line 2557: l_acc_ref_no hr_organization_information.org_information6%type;

2553: instr(pact.legislative_parameters||' ',' ', instr(pact.legislative_parameters,'TAX_REF=')+8) -
2554: instr(pact.legislative_parameters, 'TAX_REF=') - 8) = hoi.org_information1;
2555:
2556: l_payroll_rec csr_payroll_details%rowtype;
2557: l_acc_ref_no hr_organization_information.org_information6%type;
2558: l_action_info_id NUMBER(15);
2559: l_ovn NUMBER;
2560: l_exp exception;
2561: ---------------------

Line 2595: from hr_organization_information hoi

2591: select nvl(hoi.org_information11,' ') sender_id,
2592: nvl(upper(hoi.org_information2),' ') hrmc_office,
2593: nvl(upper(hoi.org_information4),' ') er_addr,
2594: nvl(upper(hoi.org_information3),' ') er_name
2595: from hr_organization_information hoi
2596: where hoi.organization_id = p_bus_id
2597: and hoi.org_information_context = 'Tax Details References'
2598: and nvl(hoi.org_information10,'UK') = 'UK'
2599: and upper(hoi.org_information1) = upper(p_tax_ref);