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

Line 1034: FROM dual;

1030: AND pbt.legislation_code = 'GB';
1031: CURSOR csr_tax_pay_value(p_last_asg_action_id NUMBER,l_tax_pay_def_bal_id NUMBER)
1032: IS
1033: SELECT hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id)
1034: FROM dual;
1035:
1036: cursor csr_reversal is
1037: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa
1038: where paa.assignment_action_id = l_last_asg_action_id

Line 1365: FROM dual;

1361: AND pbt.legislation_code = 'GB';
1362: CURSOR csr_tax_pay_value(p_last_asg_action_id NUMBER,l_tax_pay_def_bal_id NUMBER)
1363: IS
1364: SELECT hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id)
1365: FROM dual;
1366:
1367: cursor csr_reversal is
1368: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa
1369: where paa.assignment_action_id = l_last_asg_action_id

Line 1703: FROM dual;

1699: AND pbt.legislation_code = 'GB';
1700: CURSOR csr_tax_pay_value(p_last_asg_action_id NUMBER,l_tax_pay_def_bal_id NUMBER)
1701: IS
1702: SELECT hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id)
1703: FROM dual;
1704:
1705: cursor csr_reversal is
1706: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa
1707: where paa.assignment_action_id = l_last_asg_action_id

Line 2373: FROM dual;

2369: AND pbt.legislation_code = 'GB';
2370: CURSOR csr_tax_pay_value(p_last_asg_action_id NUMBER,l_tax_pay_def_bal_id NUMBER)
2371: IS
2372: SELECT hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id)
2373: FROM dual;
2374:
2375: cursor csr_reversal is
2376: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa
2377: where paa.assignment_action_id = l_last_asg_action_id

Line 2658: FROM dual;

2654: AND pbt.legislation_code = 'GB';
2655: CURSOR csr_tax_pay_value(p_last_asg_action_id NUMBER,l_tax_pay_def_bal_id NUMBER)
2656: IS
2657: SELECT hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id)
2658: FROM dual;
2659: BEGIN
2660: hr_utility.trace('Entering PAY_GB_FPS_NI_AND_OTHERS_13.get_ni_only_agg_bal_sum_asg.');
2661: load_defined_balances();
2662: -- fetch NI x Total/Able balances for checking whether this assignment