DBA Data[Home] [Help]

APPS.GR_PROCESS_DOCUMENTS dependencies on GR_SUB_HEADINGS_B

Line 64: G_SUB_HEADING GR_SUB_HEADINGS_B.sub_heading_code%TYPE;

60: G_ML_ITEM GR_ITEM_GENERAL.item_code%TYPE;
61: G_CURRENT_LABEL GR_LABELS_B.label_code%TYPE;
62: G_OPM_VERSION FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
63: G_MAIN_HEADING GR_MAIN_HEADINGS_B.main_heading_code%TYPE;
64: G_SUB_HEADING GR_SUB_HEADINGS_B.sub_heading_code%TYPE;
65: G_LABEL_CODE GR_LABELS_B.label_code%TYPE;
66: G_LANGUAGE_CODE FND_LANGUAGES.language_code%TYPE;
67: G_RECIP_PRINTED VARCHAR2(2) := 'NO';
68: G_VENDOR_PRINTED VARCHAR2(2) := 'NO';

Line 267: gr_sub_headings_b shb

263: SELECT shb.sub_heading_print_font,
264: shb.sub_heading_print_size,
265: sht.sub_heading_desc
266: FROM gr_sub_headings_tl sht,
267: gr_sub_headings_b shb
268: WHERE shb.sub_heading_code = g_sub_heading
269: AND sht.sub_heading_code = g_sub_heading
270: AND sht.language = g_language_code;
271: GlobalSubHeading g_get_sub_heading%ROWTYPE;