APPS.PAY_GB_RTI_FPS_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 7892: l_sender_id hr_organization_information.org_information11%TYPE;

7888: p_payroll_action_id IN NUMBER)
7889: IS
7890: error_found EXCEPTION;
7891: l_proc CONSTANT VARCHAR2(50) := g_package || ' archinit';
7892: l_sender_id hr_organization_information.org_information11%TYPE;
7893: l_tax_ref hr_organization_information.org_information1%TYPE;
7894: l_tax_dist hr_organization_information.org_information2%TYPE;
7895: l_employer_addr VARCHAR2(255);
7896: l_employer_name VARCHAR2(150);

Line 7893: l_tax_ref hr_organization_information.org_information1%TYPE;

7889: IS
7890: error_found EXCEPTION;
7891: l_proc CONSTANT VARCHAR2(50) := g_package || ' archinit';
7892: l_sender_id hr_organization_information.org_information11%TYPE;
7893: l_tax_ref hr_organization_information.org_information1%TYPE;
7894: l_tax_dist hr_organization_information.org_information2%TYPE;
7895: l_employer_addr VARCHAR2(255);
7896: l_employer_name VARCHAR2(150);
7897: l_err BOOLEAN;

Line 7894: l_tax_dist hr_organization_information.org_information2%TYPE;

7890: error_found EXCEPTION;
7891: l_proc CONSTANT VARCHAR2(50) := g_package || ' archinit';
7892: l_sender_id hr_organization_information.org_information11%TYPE;
7893: l_tax_ref hr_organization_information.org_information1%TYPE;
7894: l_tax_dist hr_organization_information.org_information2%TYPE;
7895: l_employer_addr VARCHAR2(255);
7896: l_employer_name VARCHAR2(150);
7897: l_err BOOLEAN;
7898: l_exp EXCEPTION;

Line 7942: hr_organization_information hoi

7938: DECODE(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,
7939: NVL(upper(SUBSTR(hoi.org_information6,1,13)),' ') acc_ref_no,
7940: report_type
7941: FROM pay_payroll_actions pact,
7942: hr_organization_information hoi
7943: WHERE pact.payroll_action_id =pactid
7944: AND pact.business_group_id = hoi.organization_id
7945: AND hoi.org_information_context = 'Tax Details References'
7946: AND NVL(hoi.org_information10,'UK') = 'UK'

Line 13120: hr_organization_information hoi

13116: pact.business_group_id bus_grp_id,
13117: pact.action_parameter_group_id act_param_grp_id,
13118: org_information19 service_company
13119: FROM pay_payroll_actions pact,
13120: hr_organization_information hoi
13121: WHERE pact.payroll_action_id =pactid
13122: AND pact.business_group_id = hoi.organization_id
13123: AND hoi.org_information_context = 'Tax Details References'
13124: AND NVL(hoi.org_information10,'UK') = 'UK'

Line 13132: from hr_organization_information hoi

13128: cursor csr_payroll_details_2(paye_ref VARCHAR2,orgid number) is
13129: select
13130: hoi.org_information2 sautr,
13131: hoi.org_information3 cotaxref
13132: from hr_organization_information hoi
13133: where hoi.organization_id = orgid
13134: and hoi.org_information_context = 'Tax Details References Cont'
13135: and hoi.org_information1 = paye_ref;
13136:

Line 13204: FROM hr_organization_information hoi

13200: SELECT NVL(hoi.org_information11,' ') sender_id,
13201: NVL(upper(hoi.org_information2),' ') hrmc_office,
13202: NVL(upper(hoi.org_information4),' ') er_addr,
13203: NVL(upper(hoi.org_information3),' ') er_name
13204: FROM hr_organization_information hoi
13205: WHERE hoi.organization_id = p_bus_id
13206: AND hoi.org_information_context = 'Tax Details References'
13207: AND NVL(hoi.org_information10,'UK') = 'UK'
13208: AND upper(hoi.org_information1) = upper(p_tax_ref);