eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_RTI_EAS dependencies on HR_ORGANIZATION_INFORMATION

Line 2139: l_paye_ref hr_organization_information.org_information1%TYPE;

2135: l_employee_number varchar2(25);
2136: -- l_assignment_set will have the Assignment Set parameter from the NINO Program
2137: l_assignment_set varchar2(25);
2138:
2139: l_paye_ref hr_organization_information.org_information1%TYPE;
2140: l_err BOOLEAN;
2141: l_exp EXCEPTION;
2142:
2143: l_proc CONSTANT VARCHAR2(35):= g_package||'range_cursor';

Line 2154: hr_organization_information hoi

2150: substr(pay_gb_eoy_archive.get_parameter(pact.legislative_parameters,'PERMIT'),1,12) unique_part_id,
2151: report_type,
2152: business_group_id
2153: from pay_payroll_actions pact,
2154: hr_organization_information hoi
2155: where pact.payroll_action_id=pactid
2156: and pact.business_group_id = hoi.organization_id
2157: and hoi.org_information_context = 'Tax Details References'
2158: and nvl(hoi.org_information10,'UK') = 'UK'

Line 2395: hr_organization_information org

2391: per_assignment_status_types past,
2392: per_periods_of_service serv,
2393: pay_all_payrolls_f pay,
2394: hr_soft_coding_keyflex sck,
2395: hr_organization_information org
2396: where pap.person_id between stperson and endperson
2397: and pap.current_employee_flag = 'Y'
2398: and pap.person_id = asg.person_id
2399: and asg.business_group_id = l_business_group_id

Line 2434: hr_organization_information org

2430: per_all_assignments_f asg,
2431: per_periods_of_service serv,
2432: pay_all_payrolls_f pay,
2433: hr_soft_coding_keyflex sck,
2434: hr_organization_information org
2435: where pap.person_id between stperson and endperson
2436: and serv.actual_termination_date is not null
2437: and pap.person_id = asg.person_id
2438: and asg.business_group_id = l_business_group_id

Line 2849: l_sender_id hr_organization_information.org_information11%TYPE;

2845: PROCEDURE archinit(p_payroll_action_id IN NUMBER)
2846: IS
2847: l_proc CONSTANT VARCHAR2(50) := g_package || ' archinit';
2848:
2849: l_sender_id hr_organization_information.org_information11%TYPE;
2850: l_tax_ref hr_organization_information.org_information1%TYPE;
2851: l_tax_dist hr_organization_information.org_information2%TYPE;
2852: l_paye_ref hr_organization_information.org_information1%TYPE;
2853: l_employer_addr VARCHAR2(255);

Line 2850: l_tax_ref hr_organization_information.org_information1%TYPE;

2846: IS
2847: l_proc CONSTANT VARCHAR2(50) := g_package || ' archinit';
2848:
2849: l_sender_id hr_organization_information.org_information11%TYPE;
2850: l_tax_ref hr_organization_information.org_information1%TYPE;
2851: l_tax_dist hr_organization_information.org_information2%TYPE;
2852: l_paye_ref hr_organization_information.org_information1%TYPE;
2853: l_employer_addr VARCHAR2(255);
2854: l_employer_name VARCHAR2(150);

Line 2851: l_tax_dist hr_organization_information.org_information2%TYPE;

2847: l_proc CONSTANT VARCHAR2(50) := g_package || ' archinit';
2848:
2849: l_sender_id hr_organization_information.org_information11%TYPE;
2850: l_tax_ref hr_organization_information.org_information1%TYPE;
2851: l_tax_dist hr_organization_information.org_information2%TYPE;
2852: l_paye_ref hr_organization_information.org_information1%TYPE;
2853: l_employer_addr VARCHAR2(255);
2854: l_employer_name VARCHAR2(150);
2855: l_err BOOLEAN;

Line 2852: l_paye_ref hr_organization_information.org_information1%TYPE;

2848:
2849: l_sender_id hr_organization_information.org_information11%TYPE;
2850: l_tax_ref hr_organization_information.org_information1%TYPE;
2851: l_tax_dist hr_organization_information.org_information2%TYPE;
2852: l_paye_ref hr_organization_information.org_information1%TYPE;
2853: l_employer_addr VARCHAR2(255);
2854: l_employer_name VARCHAR2(150);
2855: l_err BOOLEAN;
2856: l_exp EXCEPTION;

Line 2877: hr_organization_information hoi

2873: substr(pay_gb_eoy_archive.get_parameter(pact.legislative_parameters,'PERMIT'),1,12) unique_part_id,
2874: report_type,
2875: business_group_id
2876: from pay_payroll_actions pact,
2877: hr_organization_information hoi
2878: where pact.payroll_action_id=pactid
2879: and pact.business_group_id = hoi.organization_id
2880: and hoi.org_information_context = 'Tax Details References'
2881: and nvl(hoi.org_information10,'UK') = 'UK'

Line 3361: hr_organization_information hoi

3357:
3358: pact.business_group_id bus_grp_id,
3359: pact.action_parameter_group_id act_param_grp_id
3360: from pay_payroll_actions pact,
3361: hr_organization_information hoi
3362: where pact.payroll_action_id=pactid
3363: and pact.business_group_id = hoi.organization_id
3364: and hoi.org_information_context = 'Tax Details References'
3365: and nvl(hoi.org_information10,'UK') = 'UK'

Line 3371: l_acc_ref_no hr_organization_information.org_information6%type;

3367: instr(pact.legislative_parameters||' ',' ', instr(pact.legislative_parameters,'TAX_REF=')+8) -
3368: instr(pact.legislative_parameters, 'TAX_REF=') - 8) = hoi.org_information1;
3369:
3370: l_payroll_rec csr_payroll_details%rowtype;
3371: l_acc_ref_no hr_organization_information.org_information6%type;
3372: l_action_info_id NUMBER(15);
3373: l_ovn NUMBER;
3374: l_exp exception;
3375: ---------------------

Line 3412: from hr_organization_information hoi

3408: select nvl(hoi.org_information11,' ') sender_id,
3409: nvl(upper(hoi.org_information2),' ') hrmc_office,
3410: nvl(upper(hoi.org_information4),' ') er_addr,
3411: nvl(upper(hoi.org_information3),' ') er_name
3412: from hr_organization_information hoi
3413: where hoi.organization_id = p_bus_id
3414: and hoi.org_information_context = 'Tax Details References'
3415: and nvl(hoi.org_information10,'UK') = 'UK'
3416: and upper(hoi.org_information1) = upper(p_tax_ref);

Line 3620: hr_organization_information hoi

3616: cursor csr_payroll_details(pactid NUMBER) is
3617: select
3618: to_date(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'START=') + 6,10),'YYYY-MM-DD') effective_date
3619: from pay_payroll_actions pact,
3620: hr_organization_information hoi
3621: where pact.payroll_action_id=pactid
3622: and pact.business_group_id = hoi.organization_id
3623: and hoi.org_information_context = 'Tax Details References'
3624: and nvl(hoi.org_information10,'UK') = 'UK'