APPS.PAY_CREATE_ELEMNT_TMPLT_RECORD dependencies on PAY_BALANCE_DIMENSIONS

Line 4949: SELECT balance_dimension_id FROM pay_balance_dimensions

4945:
4946: procedure create_all_templates(p_legislation_code in varchar2, p_currency_code in varchar2) is
4947:
4948: CURSOR c_get_taxunit_flag(cp_legislation_code IN VARCHAR2) IS
4949: SELECT balance_dimension_id FROM pay_balance_dimensions
4950: WHERE legislation_code = cp_legislation_code
4951: AND database_item_suffix = '_ASG_TU_TYTD';
4952:
4953: ln_balance_dimension_id NUMBER;