eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_YE_CLOSE dependencies on FV_FACTS_ATTRIBUTES

Line 2483: FROM Fv_Facts_Attributes

2479: PROCEDURE Determine_Processing_Type(p_type OUT NOCOPY NUMBER) IS
2480:
2481: CURSOR get_attrcnt_csr(p_acct VARCHAR2) IS
2482: SELECT COUNT(*)
2483: FROM Fv_Facts_Attributes
2484: WHERE set_of_books_id = vg_sob_id
2485: AND facts_acct_number = p_acct;
2486:
2487: CURSOR get_attributes_csr(p_acct VARCHAR2) IS

Line 2492: FROM Fv_Facts_Attributes

2488: SELECT public_law_code,
2489: advance_flag,
2490: transfer_flag,
2491: govt_non_govt
2492: FROM Fv_Facts_Attributes
2493: WHERE set_of_books_id = vg_sob_id
2494: AND facts_acct_number = p_acct;
2495:
2496: CURSOR get_parent_csr IS

Line 2503: vl_plcode Fv_Facts_Attributes.public_law_code%TYPE;

2499: WHERE flex_value_set_id = vg_acct_val_set_id
2500: AND vg_child_acct BETWEEN child_flex_value_low AND child_flex_value_high
2501: ORDER BY parent_flex_value;
2502:
2503: vl_plcode Fv_Facts_Attributes.public_law_code%TYPE;
2504: vl_advflag Fv_Facts_Attributes.advance_flag%TYPE;
2505: vl_transflag Fv_Facts_Attributes.transfer_flag%TYPE;
2506: vl_govtflag Fv_Facts_Attributes.govt_non_govt%TYPE;
2507: vl_found_flag VARCHAR2(1) ;

Line 2504: vl_advflag Fv_Facts_Attributes.advance_flag%TYPE;

2500: AND vg_child_acct BETWEEN child_flex_value_low AND child_flex_value_high
2501: ORDER BY parent_flex_value;
2502:
2503: vl_plcode Fv_Facts_Attributes.public_law_code%TYPE;
2504: vl_advflag Fv_Facts_Attributes.advance_flag%TYPE;
2505: vl_transflag Fv_Facts_Attributes.transfer_flag%TYPE;
2506: vl_govtflag Fv_Facts_Attributes.govt_non_govt%TYPE;
2507: vl_found_flag VARCHAR2(1) ;
2508: vl_cnt NUMBER;

Line 2505: vl_transflag Fv_Facts_Attributes.transfer_flag%TYPE;

2501: ORDER BY parent_flex_value;
2502:
2503: vl_plcode Fv_Facts_Attributes.public_law_code%TYPE;
2504: vl_advflag Fv_Facts_Attributes.advance_flag%TYPE;
2505: vl_transflag Fv_Facts_Attributes.transfer_flag%TYPE;
2506: vl_govtflag Fv_Facts_Attributes.govt_non_govt%TYPE;
2507: vl_found_flag VARCHAR2(1) ;
2508: vl_cnt NUMBER;
2509: vl_process_type VARCHAR2(10);

Line 2506: vl_govtflag Fv_Facts_Attributes.govt_non_govt%TYPE;

2502:
2503: vl_plcode Fv_Facts_Attributes.public_law_code%TYPE;
2504: vl_advflag Fv_Facts_Attributes.advance_flag%TYPE;
2505: vl_transflag Fv_Facts_Attributes.transfer_flag%TYPE;
2506: vl_govtflag Fv_Facts_Attributes.govt_non_govt%TYPE;
2507: vl_found_flag VARCHAR2(1) ;
2508: vl_cnt NUMBER;
2509: vl_process_type VARCHAR2(10);
2510: vl_parent Fnd_Flex_Value_Hierarchies.parent_flex_value%TYPE;