APPS.PAY_SE_ABSENCE dependencies on FF_GLOBALS_F

Line 893: SELECT nvl(global_value,0) FROM ff_globals_f WHERE --ROWNUM<3

889: AND prrv2.input_value_id = csr_v_input_type_id2; --139718 --p_start_date_iv*/
890:
891: CURSOR csr_global_value(csr_v_global_name VARCHAR2,csr_v_effective_date DATE )
892: IS
893: SELECT nvl(global_value,0) FROM ff_globals_f WHERE --ROWNUM<3
894: legislation_code='SE'
895: AND GLOBAL_NAME=csr_v_global_name --'SE_BASIC_AMOUNT'
896: AND csr_v_effective_date /*'28-feb-2007'*/ BETWEEN effective_start_date
897: AND effective_end_date;

Line 3268: SELECT nvl(global_value,0) FROM ff_globals_f WHERE --ROWNUM<3

3264: and CSTB.Template_Id=b_template_id; --10284
3265:
3266: CURSOR csr_global_value(csr_v_global_name VARCHAR2,csr_v_effective_date DATE )
3267: IS
3268: SELECT nvl(global_value,0) FROM ff_globals_f WHERE --ROWNUM<3
3269: legislation_code='SE'
3270: AND GLOBAL_NAME=csr_v_global_name --'SE_BASIC_AMOUNT'
3271: AND csr_v_effective_date /*'28-feb-2007'*/ BETWEEN effective_start_date
3272: AND effective_end_date;