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 2012: FROM pay_defined_balances

2008: /* Cursor to get the defined balance id */
2009:
2010: CURSOR csr_def_bal_id (p_prim_bal_type_id NUMBER)IS
2011: SELECT defined_balance_id
2012: FROM pay_defined_balances
2013: WHERE balance_type_id = p_prim_bal_type_id
2014: AND ((business_group_id IS NULL AND legislation_code = 'NO')
2015: OR (business_group_id = g_business_group_id AND legislation_code IS NULL))
2016: AND balance_dimension_id = ( select balance_dimension_id

Line 3390: FROM pay_defined_balances

3386: -----------------
3387: /* Cursor to fetch defined balance id */
3388: CURSOR csr_def_balance(bal_type_id NUMBER, bal_dim_id NUMBER) IS
3389: SELECT defined_balance_id
3390: FROM pay_defined_balances
3391: WHERE balance_type_id = bal_type_id
3392: AND balance_dimension_id = bal_dim_id;
3393: ----------------
3394: rec_get_balance csr_get_balance%ROWTYPE;

Line 3979: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

3975: l_rec get_details%ROWTYPE;
3976: l_tax_rec csr_tax_details%ROWTYPE;
3977: l_action_info_id pay_action_information.action_information_id%TYPE;
3978: l_tax_category hr_soft_coding_keyflex.segment13%TYPE;
3979: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
3980:
3981: l_work_title hr_soft_coding_keyflex.segment4%type := NULL ;
3982: l_net_salary_ptd NUMBER;
3983: l_net_salary_ytd NUMBER;