APPS.FV_FACTS_EDIT_CHECK dependencies on FV_FACTS2_CLOSING_VALIDATION

Line 1433: fv_facts2_closing_validation clos

1429: IS
1430: SELECT SUM(tmp.amount) amt,
1431: clos.authority_code auth_type
1432: FROM fv_facts_temp tmp,
1433: fv_facts2_closing_validation clos
1434: WHERE tmp.treasury_symbol_id = g_treasury_symbol_id
1435: and tmp.fct_int_record_category='REPORTED_NEW'
1436: and tmp.fct_int_record_type='BLK_DTL'
1437: AND tmp.sgl_acct_number = clos.ussgl_account

Line 1449: fv_facts2_closing_validation clos

1445: SELECT bal.ending_bal,
1446: bal.ussgl_account ,
1447: bal.authority_type
1448: FROM fv_facts2_retain_bal bal,
1449: fv_facts2_closing_validation clos
1450: WHERE bal.treasury_symbol_id = g_treasury_symbol_id
1451: AND clos.closing_grp = p_closing_grp
1452: AND bal.closing_grp = p_closing_grp
1453: AND bal.period_year = l_prior_year

Line 1464: FROM fv_facts2_closing_validation

1460:
1461: CURSOR get_all_closing_acct
1462: IS
1463: SELECT closing_grp, ussgl_account
1464: FROM fv_facts2_closing_validation
1465: WHERE closing_acct_flag='Y'
1466: ORDER BY closing_grp;
1467:
1468: BEGIN

Line 1518: fv_facts2_closing_validation clos

1514:
1515: SELECT COUNT(*)
1516: INTO l_temp_count
1517: FROM fv_facts_temp tmp,
1518: fv_facts2_closing_validation clos
1519: WHERE tmp.treasury_symbol_id = g_treasury_symbol_id
1520: AND tmp.fct_int_record_category='REPORTED_NEW'
1521: AND tmp.fct_int_record_type ='BLK_DTL'
1522: AND tmp.sgl_acct_number = clos.ussgl_account

Line 2986: fv_facts2_closing_validation clos

2982: att.authority_type,
2983: clos.closing_grp
2984: FROM fv_facts_temp tmp,
2985: fv_facts_attributes att,
2986: fv_facts2_closing_validation clos
2987: WHERE tmp.treasury_symbol_id = g_treasury_symbol_id
2988: AND tmp.begin_end = 'E'
2989: AND tmp.fct_int_record_category='REPORTED_NEW'
2990: AND tmp.fct_int_record_type='BLK_DTL'

Line 3008: fv_facts2_closing_validation clos

3004: att.authority_type,
3005: clos.closing_grp
3006: FROM fv_facts_temp tmp,
3007: fv_facts_attributes att,
3008: fv_facts2_closing_validation clos
3009: WHERE tmp.treasury_symbol_id = g_treasury_symbol_id
3010: AND tmp.begin_end = 'E'
3011: AND tmp.fct_int_record_category='REPORTED_NEW'
3012: AND tmp.fct_int_record_type='BLK_DTL'

Line 3028: fv_facts2_closing_validation clos

3024: tmp.treasury_symbol_id,
3025: tmp.authority_type,
3026: clos.closing_grp
3027: FROM fv_facts_temp tmp,
3028: fv_facts2_closing_validation clos
3029: WHERE tmp.treasury_symbol_id = g_treasury_symbol_id
3030: AND tmp.begin_end = 'E'
3031: AND tmp.fct_int_record_category='REPORTED_NEW'
3032: AND tmp.fct_int_record_type='BLK_DTL'

Line 3081: fv_facts2_closing_validation clos

3077: /* SELECT COUNT(*)
3078: INTO l_count
3079: FROM fv_facts_temp tmp,
3080: fv_facts_attributes att,
3081: fv_facts2_closing_validation clos
3082: WHERE tmp.treasury_symbol_id = g_treasury_symbol_id
3083: AND tmp.begin_end = 'E'
3084: AND tmp.sgl_acct_number = att.ussgl_acct_number
3085: AND tmp.sgl_acct_number = clos.ussgl_Account