42: SELECT multi_currency_billing_flag,
43: share_across_ou_br_sch_flag,
44: allow_funding_across_ou_flag,
45: default_rate_type,
46: pa_currency.get_currency_code,
47: competence_match_wt,
48: availability_match_wt,
49: job_level_match_wt
50: INTO x_multi_currency_billing_flag,
1396: BEGIN
1397:
1398: /* Code addition for bug 2872748 starts */
1399: begin
1400: select pa_currency.get_currency_code
1401: into l_currency_code
1402: from dual ;
1403: end;
1404: /* Code addition for bug 2872748 ends */
1406: SELECT 'N' INTO lv_return_flag FROM DUAL
1407: WHERE EXISTS ( SELECT a.agreement_id
1408: FROM pa_agreements a
1409: WHERE a.agreement_currency_code <> l_currency_code);
1410: /* for bug 2872748 replaced pa_currency.get_currency_code with l_currency_code in above sql */
1411:
1412: RETURN (lv_return_flag);
1413:
1414: EXCEPTION
1420: SELECT 'N' INTO lv_return_flag FROM DUAL
1421: WHERE EXISTS ( SELECT b.bill_rate_sch_id
1422: /* Commented for bug 2867740
1423: FROM pa_bill_rates b
1424: WHERE b.RATE_CURRENCY_CODE <> pa_currency.get_currency_code); */
1425: /* Bug fix for bug 2867740 Starts Here */
1426: FROM pa_std_bill_rate_schedules b
1427: WHERE b.RATE_SCH_CURRENCY_CODE <> pa_currency.get_currency_code);
1428: /* Bug fix for bug 2867740 Ends Here */
1423: FROM pa_bill_rates b
1424: WHERE b.RATE_CURRENCY_CODE <> pa_currency.get_currency_code); */
1425: /* Bug fix for bug 2867740 Starts Here */
1426: FROM pa_std_bill_rate_schedules b
1427: WHERE b.RATE_SCH_CURRENCY_CODE <> pa_currency.get_currency_code);
1428: /* Bug fix for bug 2867740 Ends Here */
1429: RETURN (lv_return_flag);
1430: EXCEPTION
1431: