APPS.PAY_FI_ARCHIVE_PYSA dependencies on PAY_DEFINED_BALANCES

Line 145: FROM pay_defined_balances

141: AND org_information1 = 'BALANCE';
142: /* Cursor to fetch defined balance id */
143: CURSOR csr_def_balance(bal_type_id NUMBER, bal_dim_id NUMBER) IS
144: SELECT defined_balance_id
145: FROM pay_defined_balances
146: WHERE balance_type_id = bal_type_id
147: AND balance_dimension_id = bal_dim_id;
148: -----------------------------------------------------
149: --ELEMENTS

Line 1719: FROM pay_defined_balances

1715: WHERE paa.assignment_action_id = p_run_assact_id;
1716: /* Cursor to fetch defined balance id */
1717: CURSOR csr_def_balance(bal_type_id NUMBER, bal_dim_id NUMBER) IS
1718: SELECT defined_balance_id
1719: FROM pay_defined_balances
1720: WHERE balance_type_id = bal_type_id
1721: AND balance_dimension_id = bal_dim_id;
1722: rec_get_balance csr_get_balance%ROWTYPE;
1723: l_balance_value NUMBER := 0;

Line 1903: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

1899: l_rec get_details%ROWTYPE;
1900: l_tax_rec csr_tax_details%ROWTYPE;
1901: l_action_info_id pay_action_information.action_information_id%TYPE;
1902:
1903: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
1904: l_sal_inc_ptd NUMBER(10,2);
1905: l_sal_inc_ytd NUMBER(10,2);
1906: l_bik_ptd NUMBER(10,2);
1907: l_bik_ytd NUMBER(10,2);