DBA Data[Home] [Help]

APPS.FV_REIMB_ACTIVITY_PROCESS dependencies on FND_ID_FLEX_SEGMENTS

Line 470: FROM fnd_id_flex_segments

466:
467: --This cursor fetches the value_set_id for the natural account segment
468: CURSOR flex_value_id_cur IS
469: SELECT flex_value_set_id
470: FROM fnd_id_flex_segments
471: WHERE application_id = 101
472: AND application_column_name =g_gl_nat_acc_segment
473: AND id_flex_code = g_id_flex_code
474: AND id_flex_num = g_coa_id

Line 497: FROM FND_ID_FLEX_SEGMENTS_VL

493: -- in the Federal Financial Options
494: BEGIN
495: SELECT application_column_name
496: INTO g_reimb_agreement_segment
497: FROM FND_ID_FLEX_SEGMENTS_VL
498: WHERE application_id = 101
499: AND id_flex_code = 'GL#'
500: AND id_flex_num = g_coa_id
501: AND enabled_flag = 'Y'

Line 555: FROM Fnd_Id_Flex_Segments

551:
552:
553: CURSOR seg_names_cur IS
554: SELECT application_column_name
555: FROM Fnd_Id_Flex_Segments
556: WHERE application_id = g_apps_id
557: AND id_flex_code = g_id_flex_code
558: AND id_flex_num = g_coa_id
559: ORDER BY segment_num;

Line 608: FROM Fnd_Id_Flex_Segments

604: --l_nsegs_high NUMBER;
605:
606: CURSOR seg_num_cur (p_application_column_name VARCHAR2) IS
607: SELECT segment_num
608: FROM Fnd_Id_Flex_Segments
609: WHERE application_id = g_apps_id
610: AND id_flex_code = g_id_flex_code
611: AND id_flex_num = g_coa_id
612: AND application_column_name=p_application_column_name ;

Line 1437: FROM fnd_id_flex_segments

1433: PROCEDURE get_agreement_range IS
1434:
1435: CURSOR flex_reimb_value_id_cur IS
1436: SELECT flex_value_set_id
1437: FROM fnd_id_flex_segments
1438: WHERE application_id = 101
1439: AND application_column_name =g_reimb_agreement_segment
1440: AND id_flex_code = g_id_flex_code
1441: AND id_flex_num = g_coa_id

Line 1446: FROM Fnd_Id_Flex_Segments

1442: AND enabled_flag = 'Y' ;
1443:
1444: CURSOR reimb_segment_num_cur (p_application_column_name VARCHAR2) IS
1445: SELECT segment_num
1446: FROM Fnd_Id_Flex_Segments
1447: WHERE application_id = g_apps_id
1448: AND id_flex_code = g_id_flex_code
1449: AND id_flex_num = g_coa_id
1450: AND application_column_name=p_application_column_name ;