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 2532: FROM Fv_Facts_Attributes

2528: PROCEDURE Determine_Processing_Type(p_type OUT NOCOPY NUMBER) IS
2529:
2530: CURSOR get_attrcnt_csr(p_acct VARCHAR2) IS
2531: SELECT COUNT(*)
2532: FROM Fv_Facts_Attributes
2533: WHERE set_of_books_id = vg_sob_id
2534: AND facts_acct_number = p_acct;
2535:
2536: CURSOR get_attributes_csr(p_acct VARCHAR2) IS

Line 2541: FROM Fv_Facts_Attributes

2537: SELECT public_law_code,
2538: advance_flag,
2539: transfer_flag,
2540: govt_non_govt
2541: FROM Fv_Facts_Attributes
2542: WHERE set_of_books_id = vg_sob_id
2543: AND facts_acct_number = p_acct;
2544:
2545: CURSOR get_parent_csr IS

Line 2552: vl_plcode Fv_Facts_Attributes.public_law_code%TYPE;

2548: WHERE flex_value_set_id = vg_acct_val_set_id
2549: AND vg_child_acct BETWEEN child_flex_value_low AND child_flex_value_high
2550: ORDER BY parent_flex_value;
2551:
2552: vl_plcode Fv_Facts_Attributes.public_law_code%TYPE;
2553: vl_advflag Fv_Facts_Attributes.advance_flag%TYPE;
2554: vl_transflag Fv_Facts_Attributes.transfer_flag%TYPE;
2555: vl_govtflag Fv_Facts_Attributes.govt_non_govt%TYPE;
2556: vl_found_flag VARCHAR2(1) ;

Line 2553: vl_advflag Fv_Facts_Attributes.advance_flag%TYPE;

2549: AND vg_child_acct BETWEEN child_flex_value_low AND child_flex_value_high
2550: ORDER BY parent_flex_value;
2551:
2552: vl_plcode Fv_Facts_Attributes.public_law_code%TYPE;
2553: vl_advflag Fv_Facts_Attributes.advance_flag%TYPE;
2554: vl_transflag Fv_Facts_Attributes.transfer_flag%TYPE;
2555: vl_govtflag Fv_Facts_Attributes.govt_non_govt%TYPE;
2556: vl_found_flag VARCHAR2(1) ;
2557: vl_cnt NUMBER;

Line 2554: vl_transflag Fv_Facts_Attributes.transfer_flag%TYPE;

2550: ORDER BY parent_flex_value;
2551:
2552: vl_plcode Fv_Facts_Attributes.public_law_code%TYPE;
2553: vl_advflag Fv_Facts_Attributes.advance_flag%TYPE;
2554: vl_transflag Fv_Facts_Attributes.transfer_flag%TYPE;
2555: vl_govtflag Fv_Facts_Attributes.govt_non_govt%TYPE;
2556: vl_found_flag VARCHAR2(1) ;
2557: vl_cnt NUMBER;
2558: vl_process_type VARCHAR2(10);

Line 2555: vl_govtflag Fv_Facts_Attributes.govt_non_govt%TYPE;

2551:
2552: vl_plcode Fv_Facts_Attributes.public_law_code%TYPE;
2553: vl_advflag Fv_Facts_Attributes.advance_flag%TYPE;
2554: vl_transflag Fv_Facts_Attributes.transfer_flag%TYPE;
2555: vl_govtflag Fv_Facts_Attributes.govt_non_govt%TYPE;
2556: vl_found_flag VARCHAR2(1) ;
2557: vl_cnt NUMBER;
2558: vl_process_type VARCHAR2(10);
2559: vl_parent Fnd_Flex_Value_Hierarchies.parent_flex_value%TYPE;