APPS.OKS_AUTO_REMINDER dependencies on OKS_REPORT_TEMPLATES

Line 2146: FROM oks_report_templates

2142: template_set_type,
2143: report_id,
2144: attachment_name,
2145: sts_code
2146: FROM oks_report_templates
2147: WHERE template_set_id = l_template_set
2148: AND ( DECODE (process_code,
2149: 'B', 'B',
2150: 'X'

Line 2178: FROM oks_report_templates

2174: template_set_type,
2175: report_id,
2176: attachment_name,
2177: sts_code
2178: FROM oks_report_templates
2179: WHERE template_set_id = p_template_set
2180: AND report_duration = p_duration
2181: AND report_period = p_period
2182: AND ( DECODE (process_code,

Line 2211: FROM oks_report_templates

2207: template_set_type,
2208: report_id,
2209: attachment_name,
2210: sts_code
2211: FROM oks_report_templates
2212: WHERE template_set_id = p_template_set
2213: AND report_duration = p_duration
2214: AND ( DECODE (process_code,
2215: 'B', 'B',

Line 2239: l_process_code oks_report_templates_v.process_code%TYPE;

2235:
2236: l_api_name CONSTANT VARCHAR2 (30) := 'validate_autoreminder_k';
2237: l_item_key wf_items.item_key%TYPE := '';
2238: l_online_yn VARCHAR2 (1) := 'N';
2239: l_process_code oks_report_templates_v.process_code%TYPE;
2240: l_applies_to oks_report_templates_v.applies_to%TYPE;
2241: l_salesrep_id NUMBER;
2242: l_salesrep_name VARCHAR2 (1000);
2243:

Line 2240: l_applies_to oks_report_templates_v.applies_to%TYPE;

2236: l_api_name CONSTANT VARCHAR2 (30) := 'validate_autoreminder_k';
2237: l_item_key wf_items.item_key%TYPE := '';
2238: l_online_yn VARCHAR2 (1) := 'N';
2239: l_process_code oks_report_templates_v.process_code%TYPE;
2240: l_applies_to oks_report_templates_v.applies_to%TYPE;
2241: l_salesrep_id NUMBER;
2242: l_salesrep_name VARCHAR2 (1000);
2243:
2244: CURSOR csr_k_hdr_details IS