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_FPS dependencies on HR_DIRBAL

Line 4535: select hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id) from dual;

4531: pbt.legislation_code = 'GB';
4532:
4533: cursor csr_tax_pay_value(p_last_asg_action_id number,l_tax_pay_def_bal_id number)
4534: is
4535: select hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id) from dual;
4536:
4537: CURSOR csr_max_child_act_id(c_lst_act_id NUMBER)
4538: IS
4539: SELECT max(assignment_action_id)

Line 5202: select hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id) from dual;

5198: pbt.legislation_code = 'GB';
5199:
5200: cursor csr_tax_pay_value(p_last_asg_action_id number,l_tax_pay_def_bal_id number)
5201: is
5202: select hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id) from dual;
5203:
5204: CURSOR csr_max_child_act_id(c_lst_act_id NUMBER)
5205: IS
5206: SELECT max(assignment_action_id)

Line 7625: p_archive_tab.act_info2 := nvl(p_archive_tab.act_info2,0) + nvl(100* hr_dirbal.get_balance(c_asg_act_id, l_def_bal_id),0);

7621: open csr_def_bal_id('NI ' || p_archive_tab.act_info1 || ' Able', '_ASG_TD_YTD');
7622: fetch csr_def_bal_id into l_def_bal_id;
7623: hr_utility.trace('l_def_bal_id1: ' || l_def_bal_id);
7624: close csr_def_bal_id;
7625: p_archive_tab.act_info2 := nvl(p_archive_tab.act_info2,0) + nvl(100* hr_dirbal.get_balance(c_asg_act_id, l_def_bal_id),0);
7626:
7627: open csr_def_bal_id('NI ' || p_archive_tab.act_info1 || ' Able LEL', '_ASG_TD_YTD');
7628: fetch csr_def_bal_id into l_def_bal_id;
7629: hr_utility.trace('l_def_bal_id2: ' || l_def_bal_id);

Line 7631: p_archive_tab.act_info3 := nvl(p_archive_tab.act_info3,0) + nvl(100* hr_dirbal.get_balance(c_asg_act_id, l_def_bal_id),0);

7627: open csr_def_bal_id('NI ' || p_archive_tab.act_info1 || ' Able LEL', '_ASG_TD_YTD');
7628: fetch csr_def_bal_id into l_def_bal_id;
7629: hr_utility.trace('l_def_bal_id2: ' || l_def_bal_id);
7630: close csr_def_bal_id;
7631: p_archive_tab.act_info3 := nvl(p_archive_tab.act_info3,0) + nvl(100* hr_dirbal.get_balance(c_asg_act_id, l_def_bal_id),0);
7632:
7633: open csr_def_bal_id('NI ' || p_archive_tab.act_info1 || ' Able ET', '_ASG_TD_YTD');
7634: fetch csr_def_bal_id into l_def_bal_id;
7635: hr_utility.trace('l_def_bal_id3: ' || l_def_bal_id);

Line 7637: p_archive_tab.act_info4 := nvl(p_archive_tab.act_info4,0) + nvl(100* hr_dirbal.get_balance(c_asg_act_id, l_def_bal_id),0);

7633: open csr_def_bal_id('NI ' || p_archive_tab.act_info1 || ' Able ET', '_ASG_TD_YTD');
7634: fetch csr_def_bal_id into l_def_bal_id;
7635: hr_utility.trace('l_def_bal_id3: ' || l_def_bal_id);
7636: close csr_def_bal_id;
7637: p_archive_tab.act_info4 := nvl(p_archive_tab.act_info4,0) + nvl(100* hr_dirbal.get_balance(c_asg_act_id, l_def_bal_id),0);
7638:
7639: open csr_def_bal_id('NI ' || p_archive_tab.act_info1 || ' Able UAP', '_ASG_TD_YTD');
7640: fetch csr_def_bal_id into l_def_bal_id;
7641: hr_utility.trace('l_def_bal_id4: ' || l_def_bal_id);

Line 7643: p_archive_tab.act_info5 := nvl(p_archive_tab.act_info5,0) + nvl(100* hr_dirbal.get_balance(c_asg_act_id, l_def_bal_id),0);

7639: open csr_def_bal_id('NI ' || p_archive_tab.act_info1 || ' Able UAP', '_ASG_TD_YTD');
7640: fetch csr_def_bal_id into l_def_bal_id;
7641: hr_utility.trace('l_def_bal_id4: ' || l_def_bal_id);
7642: close csr_def_bal_id;
7643: p_archive_tab.act_info5 := nvl(p_archive_tab.act_info5,0) + nvl(100* hr_dirbal.get_balance(c_asg_act_id, l_def_bal_id),0);
7644:
7645: open csr_def_bal_id('NI ' || p_archive_tab.act_info1 || ' Able UEL', '_ASG_TD_YTD');
7646: fetch csr_def_bal_id into l_def_bal_id;
7647: hr_utility.trace('l_def_bal_id5: ' || l_def_bal_id);

Line 7649: p_archive_tab.act_info6 := nvl(p_archive_tab.act_info6,0) + nvl(100* hr_dirbal.get_balance(c_asg_act_id, l_def_bal_id),0);

7645: open csr_def_bal_id('NI ' || p_archive_tab.act_info1 || ' Able UEL', '_ASG_TD_YTD');
7646: fetch csr_def_bal_id into l_def_bal_id;
7647: hr_utility.trace('l_def_bal_id5: ' || l_def_bal_id);
7648: close csr_def_bal_id;
7649: p_archive_tab.act_info6 := nvl(p_archive_tab.act_info6,0) + nvl(100* hr_dirbal.get_balance(c_asg_act_id, l_def_bal_id),0);
7650:
7651: open csr_def_bal_id('NI ' || p_archive_tab.act_info1 || ' Employer', '_ASG_TD_YTD');
7652: fetch csr_def_bal_id into l_def_bal_id;
7653: hr_utility.trace('l_def_bal_id6: ' || l_def_bal_id);

Line 7655: p_archive_tab.act_info7 := nvl(p_archive_tab.act_info7,0) + nvl(100* hr_dirbal.get_balance(c_asg_act_id, l_def_bal_id),0);

7651: open csr_def_bal_id('NI ' || p_archive_tab.act_info1 || ' Employer', '_ASG_TD_YTD');
7652: fetch csr_def_bal_id into l_def_bal_id;
7653: hr_utility.trace('l_def_bal_id6: ' || l_def_bal_id);
7654: close csr_def_bal_id;
7655: p_archive_tab.act_info7 := nvl(p_archive_tab.act_info7,0) + nvl(100* hr_dirbal.get_balance(c_asg_act_id, l_def_bal_id),0);
7656:
7657: open csr_def_bal_id('NI ' || p_archive_tab.act_info1 || ' Employee', '_ASG_TD_YTD');
7658: fetch csr_def_bal_id into l_def_bal_id;
7659: hr_utility.trace('l_def_bal_id7: ' || l_def_bal_id);

Line 7661: p_archive_tab.act_info8 := nvl(p_archive_tab.act_info8,0) + nvl(100* hr_dirbal.get_balance(c_asg_act_id, l_def_bal_id),0);

7657: open csr_def_bal_id('NI ' || p_archive_tab.act_info1 || ' Employee', '_ASG_TD_YTD');
7658: fetch csr_def_bal_id into l_def_bal_id;
7659: hr_utility.trace('l_def_bal_id7: ' || l_def_bal_id);
7660: close csr_def_bal_id;
7661: p_archive_tab.act_info8 := nvl(p_archive_tab.act_info8,0) + nvl(100* hr_dirbal.get_balance(c_asg_act_id, l_def_bal_id),0);
7662:
7663: hr_utility.trace('Leaving : add_other_asg_ni_ytd');
7664: end add_other_asg_ni_ytd;
7665: