APPS.PAY_GB_MOVDED_EDI dependencies on HR_ORGANIZATION_INFORMATION

Line 2377: l_sender_id hr_organization_information.org_information11%TYPE;

2373: /*Start Modifications for bug 7633799 fix*/
2374: /* l_sender_id VARCHAR2(30);
2375: l_tax_ref VARCHAR2(30);
2376: l_tax_dist VARCHAR2(30);*/
2377: l_sender_id hr_organization_information.org_information11%TYPE;
2378: l_tax_ref hr_organization_information.org_information1%TYPE;
2379: l_tax_dist hr_organization_information.org_information2%TYPE;
2380: /*End Modifications for bug 7633799 fix*/
2381:

Line 2378: l_tax_ref hr_organization_information.org_information1%TYPE;

2374: /* l_sender_id VARCHAR2(30);
2375: l_tax_ref VARCHAR2(30);
2376: l_tax_dist VARCHAR2(30);*/
2377: l_sender_id hr_organization_information.org_information11%TYPE;
2378: l_tax_ref hr_organization_information.org_information1%TYPE;
2379: l_tax_dist hr_organization_information.org_information2%TYPE;
2380: /*End Modifications for bug 7633799 fix*/
2381:
2382: l_employer_addr VARCHAR2(255);

Line 2379: l_tax_dist hr_organization_information.org_information2%TYPE;

2375: l_tax_ref VARCHAR2(30);
2376: l_tax_dist VARCHAR2(30);*/
2377: l_sender_id hr_organization_information.org_information11%TYPE;
2378: l_tax_ref hr_organization_information.org_information1%TYPE;
2379: l_tax_dist hr_organization_information.org_information2%TYPE;
2380: /*End Modifications for bug 7633799 fix*/
2381:
2382: l_employer_addr VARCHAR2(255);
2383: l_employer_name VARCHAR2(150);

Line 2394: hr_organization_information hoi

2390: upper(hoi.org_information2),
2391: upper(hoi.org_information3),
2392: upper(hoi.org_information4)
2393: from pay_payroll_actions pact,
2394: hr_organization_information hoi
2395: where pact.payroll_action_id = p_payroll_action_id
2396: and pact.business_group_id = hoi.organization_id
2397: and hoi.org_information_context = 'Tax Details References'
2398: and (hoi.org_information10 is null

Line 3052: from hr_organization_information hoi

3048: select nvl(hoi.org_information11,' ') sender_id,
3049: nvl(upper(hoi.org_information2),' ') hrmc_office,
3050: nvl(upper(hoi.org_information4),' ') er_addr,
3051: nvl(upper(hoi.org_information3),' ') er_name
3052: from hr_organization_information hoi
3053: where hoi.organization_id = p_bus_id
3054: and hoi.org_information_context = 'Tax Details References'
3055: and nvl(hoi.org_information10,'UK') = 'UK'
3056: and upper(hoi.org_information1) = upper(p_tax_ref);