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 926: FROM pay_balance_types

922: -- Cursor to get balance type id
923: CURSOR csr_get_bal_id
924: IS
925: SELECT balance_type_id
926: FROM pay_balance_types
927: WHERE balance_name = p_balance_name
928: AND (
929: (business_group_id = p_business_group_id)
930: OR (

Line 1976: l_ees_bal_name pay_balance_types.balance_name%TYPE;

1972: := g_proc_name || 'get_pen_balance_details';
1973: l_proc_step PLS_INTEGER;
1974: i NUMBER;
1975: l_tab_bal_name t_varchar2;
1976: l_ees_bal_name pay_balance_types.balance_name%TYPE;
1977: l_ees_bal_type_id NUMBER;
1978: l_ees_ptd_bal_id NUMBER;
1979: -- For 115.29
1980: l_ees_ytd_bal_id NUMBER;

Line 1981: l_ers_bal_name pay_balance_types.balance_name%TYPE;

1977: l_ees_bal_type_id NUMBER;
1978: l_ees_ptd_bal_id NUMBER;
1979: -- For 115.29
1980: l_ees_ytd_bal_id NUMBER;
1981: l_ers_bal_name pay_balance_types.balance_name%TYPE;
1982: l_ers_bal_type_id NUMBER;
1983: l_ers_ptd_bal_id NUMBER;
1984: -- For 115.29
1985: l_ers_ytd_bal_id NUMBER;

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

1983: l_ers_ptd_bal_id NUMBER;
1984: -- For 115.29
1985: l_ers_ytd_bal_id NUMBER;
1986: -- Commenting the below variables as they are not used
1987: /* l_add_bal_name pay_balance_types.balance_name%TYPE;
1988: l_add_bal_type_id NUMBER;
1989: l_add_ptd_bal_id NUMBER;
1990: l_ayr_bal_name pay_balance_types.balance_name%TYPE;
1991: l_ayr_bal_type_id NUMBER;

Line 1990: l_ayr_bal_name pay_balance_types.balance_name%TYPE;

1986: -- Commenting the below variables as they are not used
1987: /* l_add_bal_name pay_balance_types.balance_name%TYPE;
1988: l_add_bal_type_id NUMBER;
1989: l_add_ptd_bal_id NUMBER;
1990: l_ayr_bal_name pay_balance_types.balance_name%TYPE;
1991: l_ayr_bal_type_id NUMBER;
1992: l_ayr_ptd_bal_id NUMBER;
1993: l_fwd_bal_name pay_balance_types.balance_name%TYPE;
1994: l_fwd_bal_type_id NUMBER;

Line 1993: l_fwd_bal_name pay_balance_types.balance_name%TYPE;

1989: l_add_ptd_bal_id NUMBER;
1990: l_ayr_bal_name pay_balance_types.balance_name%TYPE;
1991: l_ayr_bal_type_id NUMBER;
1992: l_ayr_ptd_bal_id NUMBER;
1993: l_fwd_bal_name pay_balance_types.balance_name%TYPE;
1994: l_fwd_bal_type_id NUMBER;
1995: l_fwd_ptd_bal_id NUMBER; */
1996: l_ayfwd_bal_name pay_balance_types.balance_name%TYPE;
1997: l_ayfwd_bal_type_id NUMBER;

Line 1996: l_ayfwd_bal_name pay_balance_types.balance_name%TYPE;

1992: l_ayr_ptd_bal_id NUMBER;
1993: l_fwd_bal_name pay_balance_types.balance_name%TYPE;
1994: l_fwd_bal_type_id NUMBER;
1995: l_fwd_ptd_bal_id NUMBER; */
1996: l_ayfwd_bal_name pay_balance_types.balance_name%TYPE;
1997: l_ayfwd_bal_type_id NUMBER;
1998: l_ayfwd_ptd_bal_id NUMBER;
1999: -- For 115.29
2000: l_ayfwd_ytd_bal_id NUMBER;

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

1998: l_ayfwd_ptd_bal_id NUMBER;
1999: -- For 115.29
2000: l_ayfwd_ytd_bal_id NUMBER;
2001:
2002: /* l_ayfb_bal_name pay_balance_types.balance_name%TYPE; -- For Bug 6082532
2003: l_ayfb_bal_type_id NUMBER;
2004: l_ayfb_ptd_bal_id NUMBER; */
2005:
2006: l_nuvos_sa_bal_name pay_balance_types.balance_name%TYPE; -- For Nuvos

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

2002: /* l_ayfb_bal_name pay_balance_types.balance_name%TYPE; -- For Bug 6082532
2003: l_ayfb_bal_type_id NUMBER;
2004: l_ayfb_ptd_bal_id NUMBER; */
2005:
2006: l_nuvos_sa_bal_name pay_balance_types.balance_name%TYPE; -- For Nuvos
2007: l_nuvos_sa_bal_type_id NUMBER;
2008: l_nuvos_sa_ptd_bal_id NUMBER;
2009: -- For 115.29
2010: l_nuvos_sa_ytd_bal_id NUMBER;

Line 2345: l_balance_name pay_balance_types.balance_name%TYPE;

2341: l_rec_avc_eei_info pay_element_type_extra_info%ROWTYPE;
2342: l_ele_classification pay_element_classifications.classification_name%TYPE;
2343: l_element_type_id NUMBER;
2344: l_scheme_prefix pay_element_type_extra_info.eei_information18%TYPE;
2345: l_balance_name pay_balance_types.balance_name%TYPE;
2346: l_balance_type_id NUMBER;
2347: l_defined_bal_id NUMBER;
2348: -- For 115.29
2349: l_pen_defined_bal_id NUMBER;