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.PQP_GB_PSI_EARNINGS_HISTORY dependencies on PAY_BALANCE_TYPES

Line 1042: FROM pay_balance_types

1038: -- Cursor to get balance type id
1039: CURSOR csr_get_bal_id
1040: IS
1041: SELECT balance_type_id
1042: FROM pay_balance_types
1043: WHERE balance_name = p_balance_name
1044: AND (
1045: (business_group_id = p_business_group_id)
1046: OR (

Line 2101: l_ees_bal_name pay_balance_types.balance_name%TYPE;

2097: := g_proc_name || 'get_pen_balance_details';
2098: l_proc_step PLS_INTEGER;
2099: i NUMBER;
2100: l_tab_bal_name t_varchar2;
2101: l_ees_bal_name pay_balance_types.balance_name%TYPE;
2102: l_ees_bal_type_id NUMBER;
2103: l_ees_ptd_bal_id NUMBER;
2104: -- For 115.29
2105: l_ees_ytd_bal_id NUMBER;

Line 2106: l_ers_bal_name pay_balance_types.balance_name%TYPE;

2102: l_ees_bal_type_id NUMBER;
2103: l_ees_ptd_bal_id NUMBER;
2104: -- For 115.29
2105: l_ees_ytd_bal_id NUMBER;
2106: l_ers_bal_name pay_balance_types.balance_name%TYPE;
2107: l_ers_bal_type_id NUMBER;
2108: l_ers_ptd_bal_id NUMBER;
2109: -- For 115.29
2110: l_ers_ytd_bal_id NUMBER;

Line 2112: /* l_add_bal_name pay_balance_types.balance_name%TYPE;

2108: l_ers_ptd_bal_id NUMBER;
2109: -- For 115.29
2110: l_ers_ytd_bal_id NUMBER;
2111: -- Commenting the below variables as they are not used
2112: /* l_add_bal_name pay_balance_types.balance_name%TYPE;
2113: l_add_bal_type_id NUMBER;
2114: l_add_ptd_bal_id NUMBER;
2115: l_ayr_bal_name pay_balance_types.balance_name%TYPE;
2116: l_ayr_bal_type_id NUMBER;

Line 2115: l_ayr_bal_name pay_balance_types.balance_name%TYPE;

2111: -- Commenting the below variables as they are not used
2112: /* l_add_bal_name pay_balance_types.balance_name%TYPE;
2113: l_add_bal_type_id NUMBER;
2114: l_add_ptd_bal_id NUMBER;
2115: l_ayr_bal_name pay_balance_types.balance_name%TYPE;
2116: l_ayr_bal_type_id NUMBER;
2117: l_ayr_ptd_bal_id NUMBER;
2118: l_fwd_bal_name pay_balance_types.balance_name%TYPE;
2119: l_fwd_bal_type_id NUMBER;

Line 2118: l_fwd_bal_name pay_balance_types.balance_name%TYPE;

2114: l_add_ptd_bal_id NUMBER;
2115: l_ayr_bal_name pay_balance_types.balance_name%TYPE;
2116: l_ayr_bal_type_id NUMBER;
2117: l_ayr_ptd_bal_id NUMBER;
2118: l_fwd_bal_name pay_balance_types.balance_name%TYPE;
2119: l_fwd_bal_type_id NUMBER;
2120: l_fwd_ptd_bal_id NUMBER; */
2121: l_ayfwd_bal_name pay_balance_types.balance_name%TYPE;
2122: l_ayfwd_bal_type_id NUMBER;

Line 2121: l_ayfwd_bal_name pay_balance_types.balance_name%TYPE;

2117: l_ayr_ptd_bal_id NUMBER;
2118: l_fwd_bal_name pay_balance_types.balance_name%TYPE;
2119: l_fwd_bal_type_id NUMBER;
2120: l_fwd_ptd_bal_id NUMBER; */
2121: l_ayfwd_bal_name pay_balance_types.balance_name%TYPE;
2122: l_ayfwd_bal_type_id NUMBER;
2123: l_ayfwd_ptd_bal_id NUMBER;
2124: -- For 115.29
2125: l_ayfwd_ytd_bal_id NUMBER;

Line 2127: /* l_ayfb_bal_name pay_balance_types.balance_name%TYPE; -- For Bug 6082532

2123: l_ayfwd_ptd_bal_id NUMBER;
2124: -- For 115.29
2125: l_ayfwd_ytd_bal_id NUMBER;
2126:
2127: /* l_ayfb_bal_name pay_balance_types.balance_name%TYPE; -- For Bug 6082532
2128: l_ayfb_bal_type_id NUMBER;
2129: l_ayfb_ptd_bal_id NUMBER; */
2130:
2131: l_nuvos_sa_bal_name pay_balance_types.balance_name%TYPE; -- For Nuvos

Line 2131: l_nuvos_sa_bal_name pay_balance_types.balance_name%TYPE; -- For Nuvos

2127: /* l_ayfb_bal_name pay_balance_types.balance_name%TYPE; -- For Bug 6082532
2128: l_ayfb_bal_type_id NUMBER;
2129: l_ayfb_ptd_bal_id NUMBER; */
2130:
2131: l_nuvos_sa_bal_name pay_balance_types.balance_name%TYPE; -- For Nuvos
2132: l_nuvos_sa_bal_type_id NUMBER;
2133: l_nuvos_sa_ptd_bal_id NUMBER;
2134: -- For 115.29
2135: l_nuvos_sa_ytd_bal_id NUMBER;

Line 2138: l_extra_contrib_bal_name pay_balance_types.balance_name%TYPE;

2134: -- For 115.29
2135: l_nuvos_sa_ytd_bal_id NUMBER;
2136:
2137: -- For Classic Extra Contributions (Bug : 13809245)
2138: l_extra_contrib_bal_name pay_balance_types.balance_name%TYPE;
2139: l_extra_contrib_bal_type_id NUMBER;
2140: l_extra_contrib_ptd_bal_id NUMBER;
2141: l_extra_contrib_ytd_bal_id NUMBER;
2142:

Line 2501: l_balance_name pay_balance_types.balance_name%TYPE;

2497: l_rec_avc_eei_info pay_element_type_extra_info%ROWTYPE;
2498: l_ele_classification pay_element_classifications.classification_name%TYPE;
2499: l_element_type_id NUMBER;
2500: l_scheme_prefix pay_element_type_extra_info.eei_information18%TYPE;
2501: l_balance_name pay_balance_types.balance_name%TYPE;
2502: l_balance_type_id NUMBER;
2503: l_defined_bal_id NUMBER;
2504: -- For 115.29
2505: l_pen_defined_bal_id NUMBER;