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_FPS_NI_AND_OTHERS dependencies on DUAL

Line 1070: FROM dual;

1066: AND pbt.legislation_code = 'GB';
1067: CURSOR csr_tax_pay_value(p_last_asg_action_id NUMBER,l_tax_pay_def_bal_id NUMBER)
1068: IS
1069: SELECT hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id)
1070: FROM dual;
1071:
1072: cursor csr_reversal is
1073: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa
1074: where paa.assignment_action_id = l_last_asg_action_id

Line 1394: FROM dual;

1390: AND pbt.legislation_code = 'GB';
1391: CURSOR csr_tax_pay_value(p_last_asg_action_id NUMBER,l_tax_pay_def_bal_id NUMBER)
1392: IS
1393: SELECT hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id)
1394: FROM dual;
1395:
1396: cursor csr_reversal is
1397: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa
1398: where paa.assignment_action_id = l_last_asg_action_id

Line 1726: FROM dual;

1722: AND pbt.legislation_code = 'GB';
1723: CURSOR csr_tax_pay_value(p_last_asg_action_id NUMBER,l_tax_pay_def_bal_id NUMBER)
1724: IS
1725: SELECT hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id)
1726: FROM dual;
1727:
1728:
1729: cursor csr_reversal is
1730: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa

Line 2385: FROM dual;

2381: AND pbt.legislation_code = 'GB';
2382: CURSOR csr_tax_pay_value(p_last_asg_action_id NUMBER,l_tax_pay_def_bal_id NUMBER)
2383: IS
2384: SELECT hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id)
2385: FROM dual;
2386:
2387: cursor csr_reversal is
2388: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa
2389: where paa.assignment_action_id = l_last_asg_action_id

Line 2663: FROM dual;

2659: AND pbt.legislation_code = 'GB';
2660: CURSOR csr_tax_pay_value(p_last_asg_action_id NUMBER,l_tax_pay_def_bal_id NUMBER)
2661: IS
2662: SELECT hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id)
2663: FROM dual;
2664: BEGIN
2665: hr_utility.trace('Entering PAY_GB_FPS_NI_AND_OTHERS.get_ni_only_agg_bal_sum_asg.');
2666: load_defined_balances();
2667: -- fetch NI x Total/Able balances for checking whether this assignment