APPS.FUN_PERIOD_STATUS_PKG dependencies on FUN_TCA_PKG

Line 278: and fun_tca_pkg.get_ou_id(fth.recipient_id) = p_org_id

274: ftb.trx_type_id=fps.trx_type_id and
275: ftb.gl_date >= fps.start_date and ftb.gl_date <=
276: fps.end_date and fps.period_name = l_prd_name and
277: fth.status not in ('NEW', 'REJECTED', 'COMPLETE')
278: and fun_tca_pkg.get_ou_id(fth.recipient_id) = p_org_id
279: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')
280: AND fps.inteco_period_type=nvl(fso.inteco_period_type,'~~'));
281: cursor c_open_int_ap(l_prd_name in Varchar2) is
282: Select 1 from dual where exists

Line 302: and fun_tca_pkg.get_ou_id(fth.initiator_id) = p_org_id);

298: ftb.trx_type_id=fps.trx_type_id and
299: ftb.gl_date >= fps.start_date and ftb.gl_date <=
300: fps.end_date and fps.period_name = l_prd_name and
301: fth.status not in ('NEW', 'REJECTED', 'COMPLETE', 'XFER_AR')
302: and fun_tca_pkg.get_ou_id(fth.initiator_id) = p_org_id);
303: cursor c_open_int_ar(l_prd_name in Varchar2) is
304: Select 1 from dual where exists
305: (Select 'X' from
306: ra_interface_lines_all ri,