APPS.JL_CMERGE dependencies on GL_PERIODS

Line 984: gl_periods gp

980: jb.personnel_id venid,
981: SUM(DECODE(jb.trans_value_sign,'D',-1*jb.trans_value,jb.trans_value)) bal,
982: jb.org_id org_id
983: FROM jl_br_journals jb,
984: gl_periods gp
985: WHERE application_id=222
986: AND journal_balance_flag='N'
987: AND jb.period_name = gp.period_name
988: AND jb.period_set_name = gp.period_set_name

Line 1005: from gl_periods

1001: cursor c_per is
1002: select period_name pername,
1003: period_year peryear,
1004: period_num pernum
1005: from gl_periods
1006: where period_set_name = pl_per_set
1007: and (period_year = pl_max_pyear
1008: and period_num > pl_max_pnum)
1009: or (period_year > pl_max_pyear

Line 1256: gl_periods g

1252: sysdate,
1253: pl_user,
1254: b.org_id
1255: FROM jl_br_balances b,
1256: gl_periods g
1257: WHERE b.application_id = 222
1258: and b.period_set_name = g.period_set_name
1259: and b.period_year = g.period_year
1260: and b.period_year = pl_max_pyear

Line 1389: FROM gl_periods

1385: pl_user,
1386: sysdate,
1387: pl_user,
1388: r_bmb.org_id
1389: FROM gl_periods
1390: WHERE period_set_name = r_bmb.perset
1391: AND (r_bmb.pyear = pl_min_pyear
1392: AND period_year = pl_min_pyear
1393: AND period_num >= r_bmb.pnum