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

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

5129: pbt.legislation_code = 'GB';
5130:
5131: cursor csr_tax_pay_value(p_last_asg_action_id number,l_tax_pay_def_bal_id number)
5132: is
5133: select hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id) from dual;
5134:
5135: CURSOR csr_max_child_act_id(c_lst_act_id NUMBER)
5136: IS
5137: SELECT max(assignment_action_id)

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

5812: pbt.legislation_code = 'GB';
5813:
5814: cursor csr_tax_pay_value(p_last_asg_action_id number,l_tax_pay_def_bal_id number)
5815: is
5816: select hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id) from dual;
5817:
5818: CURSOR csr_max_child_act_id(c_lst_act_id NUMBER)
5819: IS
5820: SELECT max(assignment_action_id)

Line 8254: 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);

8250: open csr_def_bal_id('NI ' || p_archive_tab.act_info1 || ' Able', '_ASG_TD_YTD');
8251: fetch csr_def_bal_id into l_def_bal_id;
8252: hr_utility.trace('l_def_bal_id1: ' || l_def_bal_id);
8253: close csr_def_bal_id;
8254: 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);
8255:
8256: open csr_def_bal_id('NI ' || p_archive_tab.act_info1 || ' Able LEL', '_ASG_TD_YTD');
8257: fetch csr_def_bal_id into l_def_bal_id;
8258: hr_utility.trace('l_def_bal_id2: ' || l_def_bal_id);

Line 8260: 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);

8256: open csr_def_bal_id('NI ' || p_archive_tab.act_info1 || ' Able LEL', '_ASG_TD_YTD');
8257: fetch csr_def_bal_id into l_def_bal_id;
8258: hr_utility.trace('l_def_bal_id2: ' || l_def_bal_id);
8259: close csr_def_bal_id;
8260: 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);
8261:
8262: open csr_def_bal_id('NI ' || p_archive_tab.act_info1 || ' Able ET', '_ASG_TD_YTD');
8263: fetch csr_def_bal_id into l_def_bal_id;
8264: hr_utility.trace('l_def_bal_id3: ' || l_def_bal_id);

Line 8266: 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);

8262: open csr_def_bal_id('NI ' || p_archive_tab.act_info1 || ' Able ET', '_ASG_TD_YTD');
8263: fetch csr_def_bal_id into l_def_bal_id;
8264: hr_utility.trace('l_def_bal_id3: ' || l_def_bal_id);
8265: close csr_def_bal_id;
8266: 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);
8267:
8268: open csr_def_bal_id('NI ' || p_archive_tab.act_info1 || ' Able UAP', '_ASG_TD_YTD');
8269: fetch csr_def_bal_id into l_def_bal_id;
8270: hr_utility.trace('l_def_bal_id4: ' || l_def_bal_id);

Line 8272: 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);

8268: open csr_def_bal_id('NI ' || p_archive_tab.act_info1 || ' Able UAP', '_ASG_TD_YTD');
8269: fetch csr_def_bal_id into l_def_bal_id;
8270: hr_utility.trace('l_def_bal_id4: ' || l_def_bal_id);
8271: close csr_def_bal_id;
8272: 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);
8273:
8274: open csr_def_bal_id('NI ' || p_archive_tab.act_info1 || ' Able UEL', '_ASG_TD_YTD');
8275: fetch csr_def_bal_id into l_def_bal_id;
8276: hr_utility.trace('l_def_bal_id5: ' || l_def_bal_id);

Line 8278: 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);

8274: open csr_def_bal_id('NI ' || p_archive_tab.act_info1 || ' Able UEL', '_ASG_TD_YTD');
8275: fetch csr_def_bal_id into l_def_bal_id;
8276: hr_utility.trace('l_def_bal_id5: ' || l_def_bal_id);
8277: close csr_def_bal_id;
8278: 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);
8279:
8280: open csr_def_bal_id('NI ' || p_archive_tab.act_info1 || ' Employer', '_ASG_TD_YTD');
8281: fetch csr_def_bal_id into l_def_bal_id;
8282: hr_utility.trace('l_def_bal_id6: ' || l_def_bal_id);

Line 8284: 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);

8280: open csr_def_bal_id('NI ' || p_archive_tab.act_info1 || ' Employer', '_ASG_TD_YTD');
8281: fetch csr_def_bal_id into l_def_bal_id;
8282: hr_utility.trace('l_def_bal_id6: ' || l_def_bal_id);
8283: close csr_def_bal_id;
8284: 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);
8285:
8286: open csr_def_bal_id('NI ' || p_archive_tab.act_info1 || ' Employee', '_ASG_TD_YTD');
8287: fetch csr_def_bal_id into l_def_bal_id;
8288: hr_utility.trace('l_def_bal_id7: ' || l_def_bal_id);

Line 8290: 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);

8286: open csr_def_bal_id('NI ' || p_archive_tab.act_info1 || ' Employee', '_ASG_TD_YTD');
8287: fetch csr_def_bal_id into l_def_bal_id;
8288: hr_utility.trace('l_def_bal_id7: ' || l_def_bal_id);
8289: close csr_def_bal_id;
8290: 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);
8291:
8292: hr_utility.trace('Leaving : add_other_asg_ni_ytd');
8293: end add_other_asg_ni_ytd;
8294: