APPS.PA_MULTI_CURRENCY_BILLING dependencies on PA_CURRENCY

Line 46: pa_currency.get_currency_code,

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,

Line 1393: select pa_currency.get_currency_code

1389: BEGIN
1390:
1391: /* Code addition for bug 2872748 starts */
1392: begin
1393: select pa_currency.get_currency_code
1394: into l_currency_code
1395: from dual ;
1396: end;
1397: /* Code addition for bug 2872748 ends */

Line 1403: /* for bug 2872748 replaced pa_currency.get_currency_code with l_currency_code in above sql */

1399: SELECT 'N' INTO lv_return_flag FROM DUAL
1400: WHERE EXISTS ( SELECT a.agreement_id
1401: FROM pa_agreements a
1402: WHERE a.agreement_currency_code <> l_currency_code);
1403: /* for bug 2872748 replaced pa_currency.get_currency_code with l_currency_code in above sql */
1404:
1405: RETURN (lv_return_flag);
1406:
1407: EXCEPTION

Line 1417: WHERE b.RATE_CURRENCY_CODE <> pa_currency.get_currency_code); */

1413: SELECT 'N' INTO lv_return_flag FROM DUAL
1414: WHERE EXISTS ( SELECT b.bill_rate_sch_id
1415: /* Commented for bug 2867740
1416: FROM pa_bill_rates b
1417: WHERE b.RATE_CURRENCY_CODE <> pa_currency.get_currency_code); */
1418: /* Bug fix for bug 2867740 Starts Here */
1419: FROM pa_std_bill_rate_schedules b
1420: WHERE b.RATE_SCH_CURRENCY_CODE <> pa_currency.get_currency_code);
1421: /* Bug fix for bug 2867740 Ends Here */

Line 1420: WHERE b.RATE_SCH_CURRENCY_CODE <> pa_currency.get_currency_code);

1416: FROM pa_bill_rates b
1417: WHERE b.RATE_CURRENCY_CODE <> pa_currency.get_currency_code); */
1418: /* Bug fix for bug 2867740 Starts Here */
1419: FROM pa_std_bill_rate_schedules b
1420: WHERE b.RATE_SCH_CURRENCY_CODE <> pa_currency.get_currency_code);
1421: /* Bug fix for bug 2867740 Ends Here */
1422: RETURN (lv_return_flag);
1423: EXCEPTION
1424: