[Home] [Help]
146: v_tbal_indicator FV_FACTS_TEMP.TBAL_INDICATOR%TYPE ;
147: v_tbal_fund_value FV_FUND_PARAMETERS.FUND_VALUE%TYPE ;
148: v_tbal_acct_num varchar2(25);
149: v_edit_check_code Number ;
150: -- v_debug varchar2(1) := NVL(FND_PROFILE.VALUE('FV_DEBUG_FLAG'),'N');
151: v_fund_value FV_FUND_PARAMETERS.FUND_VALUE%TYPE ;
152: v_rec_count number(3);
153: vl_pagebreak varchar2(30);
154: v_fund_count number(3);
769: GL_CODE_COMBINATIONS GLCC
770: WHERE GLB.code_combination_id = GLCC.code_combination_id ';
771:
772: -- Data Access Security
773: das_id := fnd_profile.value('GL_ACCESS_SET_ID');
774: das_where := gl_access_set_security_pkg.get_security_clause
775: (das_id,
776: gl_access_set_security_pkg.READ_ONLY_ACCESS,
777: gl_access_set_security_pkg.CHECK_LEDGER_ID,
2255: GL_CODE_COMBINATIONS GLCC
2256: WHERE GLB.code_combination_id = GLCC.code_combination_id ';
2257:
2258: -- Data Access Security
2259: das_id := fnd_profile.value('GL_ACCESS_SET_ID');
2260: das_where := gl_access_set_security_pkg.get_security_clause
2261: (das_id,
2262: gl_access_set_security_pkg.READ_ONLY_ACCESS,
2263: gl_access_set_security_pkg.CHECK_LEDGER_ID,
2910: ' AND GLB.ledger_id = :set_of_books_id
2911: AND glb.currency_code = :currency_code ';
2912:
2913: -- Data Access Security
2914: das_id := fnd_profile.value('GL_ACCESS_SET_ID');
2915: das_where := gl_access_set_security_pkg.get_security_clause
2916: (das_id,
2917: gl_access_set_security_pkg.READ_ONLY_ACCESS,
2918: gl_access_set_security_pkg.CHECK_LEDGER_ID,
3362: 'DIRECT',
3363: vp_report_id,
3364: vp_attribute_set,
3365: vp_output_format,
3366: fnd_profile.value('GL_SET_OF_BKS_NAME'),
3367: vp_fund_low,
3368: vp_fund_high,
3369: vp_currency_code,
3370: vp_period_name);