APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 211: FROM pay_defined_balances

207:
208: /* Cursor to fetch defined balance id */
209: CURSOR csr_def_balance(bal_type_id NUMBER, bal_dim_id NUMBER) IS
210: SELECT defined_balance_id
211: FROM pay_defined_balances
212: WHERE balance_type_id = bal_type_id
213: AND balance_dimension_id = bal_dim_id;
214:
215: -----------------------------------------------------

Line 299: FROM pay_defined_balances

295: /* Cursor to get the defined balance id */
296:
297: CURSOR csr_def_bal_id (p_prim_bal_type_id NUMBER)IS
298: SELECT defined_balance_id
299: FROM pay_defined_balances
300: WHERE balance_type_id = p_prim_bal_type_id
301: AND ((business_group_id IS NULL AND legislation_code = 'NO')
302: OR (business_group_id = g_business_group_id AND legislation_code IS NULL))
303: AND balance_dimension_id = ( select balance_dimension_id

Line 2001: FROM pay_defined_balances

1997: /* Cursor to get the defined balance id */
1998:
1999: CURSOR csr_def_bal_id (p_prim_bal_type_id NUMBER)IS
2000: SELECT defined_balance_id
2001: FROM pay_defined_balances
2002: WHERE balance_type_id = p_prim_bal_type_id
2003: AND ((business_group_id IS NULL AND legislation_code = 'NO')
2004: OR (business_group_id = g_business_group_id AND legislation_code IS NULL))
2005: AND balance_dimension_id = ( select balance_dimension_id

Line 3379: FROM pay_defined_balances

3375: -----------------
3376: /* Cursor to fetch defined balance id */
3377: CURSOR csr_def_balance(bal_type_id NUMBER, bal_dim_id NUMBER) IS
3378: SELECT defined_balance_id
3379: FROM pay_defined_balances
3380: WHERE balance_type_id = bal_type_id
3381: AND balance_dimension_id = bal_dim_id;
3382: ----------------
3383: rec_get_balance csr_get_balance%ROWTYPE;

Line 3968: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

3964: l_rec get_details%ROWTYPE;
3965: l_tax_rec csr_tax_details%ROWTYPE;
3966: l_action_info_id pay_action_information.action_information_id%TYPE;
3967: l_tax_category hr_soft_coding_keyflex.segment13%TYPE;
3968: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
3969:
3970: l_work_title hr_soft_coding_keyflex.segment4%type := NULL ;
3971: l_net_salary_ptd NUMBER;
3972: l_net_salary_ytd NUMBER;