APPS.FII_RECONVERSION_PKG dependencies on GL_LEDGERS_PUBLIC_V

Line 842: FROM FII_TIME_DAY t, GL_LEDGERS_PUBLIC_V sob

838: , t.report_date, p_primary_rate_type))
839: , DECODE( p_secondary_currency, sob.currency_code, 1, NULL, NULL
840: , FII_CURRENCY.GET_RATE( sob.currency_code, p_secondary_currency
841: , t.report_date, p_secondary_rate_type))
842: FROM FII_TIME_DAY t, GL_LEDGERS_PUBLIC_V sob
843: WHERE t.report_date_julian BETWEEN p_from_date_id and p_to_date_id
844: AND EXISTS (SELECT 'This date has GL transaction'
845: FROM FII_GL_JE_SUMMARY_B gl
846: WHERE gl.time_id = t.report_date_julian

Line 889: FROM FII_TIME_DAY t, GL_LEDGERS_PUBLIC_V sob

885: , t.report_date, p_primary_rate_type))
886: , DECODE( p_secondary_currency, sob.currency_code, 1, NULL, NULL
887: , FII_CURRENCY.GET_RATE( sob.currency_code, p_secondary_currency
888: , t.report_date, p_secondary_rate_type))
889: FROM FII_TIME_DAY t, GL_LEDGERS_PUBLIC_V sob
890: WHERE t.report_date_julian BETWEEN p_from_date_id and p_to_date_id
891: AND EXISTS (SELECT /*+ parallel(ap) */ 'This date has AP transaction'
892: FROM FII_AP_INV_B ap
893: WHERE ap.account_date_id = t.report_date_julian

Line 938: FROM FII_TIME_DAY t, GL_LEDGERS_PUBLIC_V sob

934: , t.report_date, p_primary_rate_type))
935: , DECODE( p_secondary_currency, sob.currency_code, 1, NULL, NULL
936: , FII_CURRENCY.GET_RATE( sob.currency_code, p_secondary_currency
937: , t.report_date, p_secondary_rate_type))
938: FROM FII_TIME_DAY t, GL_LEDGERS_PUBLIC_V sob
939: WHERE t.report_date_julian BETWEEN p_from_date_id and p_to_date_id
940: AND EXISTS (SELECT /*+ parallel(ar) */ 'This date has AR transaction'
941: FROM FII_AR_REVENUE_B ar
942: WHERE ar.gl_date_id = t.report_date_julian

Line 1905: FROM FII_RECONV_RATES r, GL_LEDGERS_PUBLIC_V sob

1901: , DECODE(p_secondary_currency, NULL, ap.sec_amount_g
1902: , ROUND((ap.amount_b*r.secondary_rate)
1903: /p_secondary_mau)*p_secondary_mau)
1904: , sysdate, p_user_id, p_user_id
1905: FROM FII_RECONV_RATES r, GL_LEDGERS_PUBLIC_V sob
1906: WHERE r.request_id = p_request_id
1907: AND r.rate_date_id = ap.account_date_id
1908: AND r.from_currency = sob.currency_code
1909: AND sob.ledger_id = ap.ledger_id)

Line 1916: FROM FII_RECONV_RATES r2, GL_LEDGERS_PUBLIC_V sob2

1912: AND ( (p_primary_currency IS NOT NULL
1913: AND ap.prim_amount_g <>
1914: (SELECT ROUND((ap.amount_b*r2.primary_rate)
1915: /p_primary_mau)*p_primary_mau
1916: FROM FII_RECONV_RATES r2, GL_LEDGERS_PUBLIC_V sob2
1917: WHERE r2.request_id = p_request_id
1918: AND r2.rate_date_id = ap.account_date_id
1919: AND r2.from_currency = sob2.currency_code
1920: AND sob2.ledger_id = ap.ledger_id))

Line 1925: FROM FII_RECONV_RATES r3, GL_LEDGERS_PUBLIC_V sob3

1921: OR (p_secondary_currency IS NOT NULL
1922: AND ap.sec_amount_g <>
1923: (SELECT ROUND((ap.amount_b*r3.secondary_rate)
1924: /p_secondary_mau)*p_secondary_mau
1925: FROM FII_RECONV_RATES r3, GL_LEDGERS_PUBLIC_V sob3
1926: WHERE r3.request_id = p_request_id
1927: AND r3.rate_date_id = ap.account_date_id
1928: AND r3.from_currency = sob3.currency_code
1929: AND sob3.ledger_id = ap.ledger_id)));