APPS.PA_REPORT_UTIL dependencies on GL_LOOKUPS

Line 41: l_meaning gl_lookups.meaning%TYPE;

37: IS
38: l_prd_name gl_periods.period_name%TYPE;
39: l_quarter_num gl_periods.quarter_num%TYPE;
40: l_prd_yr gl_periods.period_year%TYPE;
41: l_meaning gl_lookups.meaning%TYPE;
42: l_name_desc VARCHAR2(120);
43:
44: l_period_type gl_periods.period_type%TYPE;
45: l_week_ending_date DATE;

Line 408: gl_lookups gllkups

404: FROM pa_implementations imp,
405: gl_sets_of_books gl,
406: gl_periods glper,
407: gl_period_statuses glst,
408: gl_lookups gllkups
409: WHERE imp.set_of_books_id = gl.set_of_books_id
410: AND gl.period_set_name = glper.period_set_name
411: AND gl.accounted_period_type = glper.period_type
412: AND glper.period_name = glst.period_name

Line 1057: gl_lookups gllkups

1053: FROM pa_implementations imp,
1054: gl_sets_of_books gl,
1055: gl_periods glper,
1056: gl_period_statuses glst,
1057: gl_lookups gllkups
1058: WHERE imp.set_of_books_id = gl.set_of_books_id
1059: AND gl.period_set_name = glper.period_set_name
1060: AND gl.accounted_period_type = glper.period_type
1061: AND glper.period_name = glst.period_name

Line 1072: FROM gl_lookups

1068: ORDER BY glper.period_year;
1069:
1070: /* CURSOR C4(p_sts in varchar2) IS
1071: SELECT meaning, lookup_code
1072: FROM gl_lookups
1073: WHERE lookup_type = 'CLOSING_STATUS'
1074: ANd lookup_code = p_sts;*/
1075:
1076: l_default_date DATE := SYSDATE;

Line 1090: l_sts_meaning gl_lookups.meaning%TYPE;

1086: l_period_type gl_periods.period_type%TYPE;
1087: l_week_ending_date DATE;
1088:
1089: l_period_num gl_period_statuses.effective_period_num%TYPE;
1090: l_sts_meaning gl_lookups.meaning%TYPE;
1091: l_use_default_logic VARCHAR2(1) := 'Y';
1092: l_date_format VARCHAR2(100); -- Added for Bug 2091182 and 2387429
1093: /* NPE Changes Begin*/
1094: l_def_show_percentages_by varchar2(240);

Line 1381: gl_lookups gllkups

1377: FROM pa_implementations imp,
1378: gl_sets_of_books gl,
1379: gl_periods glper,
1380: gl_period_statuses glst,
1381: gl_lookups gllkups
1382: WHERE imp.set_of_books_id = gl.set_of_books_id
1383: AND gl.period_set_name = glper.period_set_name
1384: AND gl.accounted_period_type = glper.period_type
1385: AND glper.period_name = glst.period_name

Line 1555: gl_lookups gllkups

1551: FROM pa_implementations imp,
1552: gl_sets_of_books gl,
1553: gl_periods glper,
1554: gl_period_statuses glst,
1555: gl_lookups gllkups
1556: WHERE imp.set_of_books_id = gl.set_of_books_id
1557: AND gl.period_set_name = glper.period_set_name
1558: AND gl.accounted_period_type = glper.period_type
1559: AND glper.period_name = glst.period_name