APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PAY_BALANCE_TYPES

Line 287: FROM pay_balance_types

283: /* Cursor to get the first primary balance type id for an input value id */
284:
285: CURSOR csr_prim_bal_type (p_iv_id NUMBER)IS
286: SELECT balance_type_id
287: FROM pay_balance_types
288: WHERE input_value_id = p_iv_id
289: AND ((business_group_id IS NULL AND legislation_code = 'NO')
290: OR (business_group_id = g_business_group_id AND legislation_code IS NULL))
291: AND rownum = 1 ;

Line 2000: FROM pay_balance_types

1996: /* Cursor to get the first primary balance type id for an input value id */
1997:
1998: CURSOR csr_prim_bal_type (p_iv_id NUMBER)IS
1999: SELECT balance_type_id
2000: FROM pay_balance_types
2001: WHERE input_value_id = p_iv_id
2002: AND ((business_group_id IS NULL AND legislation_code = 'NO')
2003: OR (business_group_id = g_business_group_id AND legislation_code IS NULL))
2004: AND rownum = 1 ;