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_TAX_CREDIT_PKG dependencies on PAY_RUN_RESULTS

Line 676: p_element_entry_id in PAY_RUN_RESULTS.SOURCE_ID%TYPE,

672: END Check_Daily_Rate;
673:
674: PROCEDURE Fetch_Balances(
675: p_assignment_id in PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ID%TYPE,
676: p_element_entry_id in PAY_RUN_RESULTS.SOURCE_ID%TYPE,
677: p_itd_balance OUT NOCOPY NUMBER,
678: p_ptd_balance OUT NOCOPY NUMBER
679: ) is
680:

Line 690: from pay_run_results prr,

686: cursor c_itd_asgact(p_asg in NUMBER,
687: p_ent_id in NUMBER) is
688: select prr.assignment_action_id,
689: prr.source_id
690: from pay_run_results prr,
691: pay_element_types_f ele
692: where prr.assignment_action_id in (
693: SELECT to_number(substr(max(lpad(paa.action_sequence,15,'0')||
694: paa.assignment_action_id),16))

Line 714: from pay_run_results prr,

710: cursor c_ptd_asgact(p_asg in NUMBER,
711: p_ent in NUMBER) is
712: select prr.assignment_action_id,
713: prr.source_id
714: from pay_run_results prr,
715: pay_element_types_f ele
716: where prr.assignment_action_id in (
717: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||
718: paa.assignment_action_id),16))

Line 740: l_itd_source_id PAY_RUN_RESULTS.source_id%TYPE;

736: and prr.source_id = p_ent;
737:
738: l_proc VARCHAR(72) := g_package||'.FETCH_BALANCES';
739: l_itd_action_id PAY_ASSIGNMENT_ACTIONS.assignment_action_id%TYPE;
740: l_itd_source_id PAY_RUN_RESULTS.source_id%TYPE;
741: l_ptd_action_id PAY_ASSIGNMENT_ACTIONS.assignment_action_id%TYPE;
742: l_ptd_source_id PAY_RUN_RESULTS.source_id%TYPE;
743: l_balance_type_id PAY_BALANCE_TYPES.balance_type_id%TYPE;
744: l_effective_date DATE;

Line 742: l_ptd_source_id PAY_RUN_RESULTS.source_id%TYPE;

738: l_proc VARCHAR(72) := g_package||'.FETCH_BALANCES';
739: l_itd_action_id PAY_ASSIGNMENT_ACTIONS.assignment_action_id%TYPE;
740: l_itd_source_id PAY_RUN_RESULTS.source_id%TYPE;
741: l_ptd_action_id PAY_ASSIGNMENT_ACTIONS.assignment_action_id%TYPE;
742: l_ptd_source_id PAY_RUN_RESULTS.source_id%TYPE;
743: l_balance_type_id PAY_BALANCE_TYPES.balance_type_id%TYPE;
744: l_effective_date DATE;
745:
746: BEGIN