42: and
43: ( exists
44: ( select 1
45: from org_access o
46: where o.responsibility_id = fnd_global.resp_id
47: and o.resp_application_id = fnd_global.resp_appl_id
48: and o.organization_id = mp.organization_id ) or
49: ( not exists ( select 1
50: from org_access ora
43: ( exists
44: ( select 1
45: from org_access o
46: where o.responsibility_id = fnd_global.resp_id
47: and o.resp_application_id = fnd_global.resp_appl_id
48: and o.organization_id = mp.organization_id ) or
49: ( not exists ( select 1
50: from org_access ora
51: where mp.organization_id = ora.organization_id
66: g_secondary_global_ccy_code := bis_common_parameters.get_secondary_currency_code;
67:
68: end if;
69:
70: if nvl(g_resp_id,-5) <> fnd_global.resp_id or
71: nvl(g_resp_appl_id,-5) <> fnd_global.resp_appl_id or
72: nvl(g_org,'NULL') <> p_selected_org then
73:
74: g_resp_id := fnd_global.resp_id;
67:
68: end if;
69:
70: if nvl(g_resp_id,-5) <> fnd_global.resp_id or
71: nvl(g_resp_appl_id,-5) <> fnd_global.resp_appl_id or
72: nvl(g_org,'NULL') <> p_selected_org then
73:
74: g_resp_id := fnd_global.resp_id;
75: g_resp_appl_id := fnd_global.resp_appl_id;
70: if nvl(g_resp_id,-5) <> fnd_global.resp_id or
71: nvl(g_resp_appl_id,-5) <> fnd_global.resp_appl_id or
72: nvl(g_org,'NULL') <> p_selected_org then
73:
74: g_resp_id := fnd_global.resp_id;
75: g_resp_appl_id := fnd_global.resp_appl_id;
76: g_org := p_selected_org;
77: g_org_ccy_code := 'FII_GLOBAL1';
78:
71: nvl(g_resp_appl_id,-5) <> fnd_global.resp_appl_id or
72: nvl(g_org,'NULL') <> p_selected_org then
73:
74: g_resp_id := fnd_global.resp_id;
75: g_resp_appl_id := fnd_global.resp_appl_id;
76: g_org := p_selected_org;
77: g_org_ccy_code := 'FII_GLOBAL1';
78:
79: if p_selected_org = 'ALL' then