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

1985: /* Cursor to get the first primary balance type id for an input value id */
1986:
1987: CURSOR csr_prim_bal_type (p_iv_id NUMBER)IS
1988: SELECT balance_type_id
1989: FROM pay_balance_types
1990: WHERE input_value_id = p_iv_id
1991: AND ((business_group_id IS NULL AND legislation_code = 'NO')
1992: OR (business_group_id = g_business_group_id AND legislation_code IS NULL))
1993: AND rownum = 1 ;