APPS.OKS_AUTO_REMINDER dependencies on OKS_REPORT_TEMPLATES

Line 2069: FROM oks_report_templates

2065: template_set_type,
2066: report_id,
2067: attachment_name,
2068: sts_code
2069: FROM oks_report_templates
2070: WHERE template_set_id = l_template_set
2071: AND ( DECODE (process_code,
2072: 'B', 'B',
2073: 'X'

Line 2101: FROM oks_report_templates

2097: template_set_type,
2098: report_id,
2099: attachment_name,
2100: sts_code
2101: FROM oks_report_templates
2102: WHERE template_set_id = p_template_set
2103: AND report_duration = p_duration
2104: AND report_period = p_period
2105: AND ( DECODE (process_code,

Line 2134: FROM oks_report_templates

2130: template_set_type,
2131: report_id,
2132: attachment_name,
2133: sts_code
2134: FROM oks_report_templates
2135: WHERE template_set_id = p_template_set
2136: AND report_duration = p_duration
2137: AND ( DECODE (process_code,
2138: 'B', 'B',

Line 2162: l_process_code oks_report_templates_v.process_code%TYPE;

2158:
2159: l_api_name CONSTANT VARCHAR2 (30) := 'validate_autoreminder_k';
2160: l_item_key wf_items.item_key%TYPE := '';
2161: l_online_yn VARCHAR2 (1) := 'N';
2162: l_process_code oks_report_templates_v.process_code%TYPE;
2163: l_applies_to oks_report_templates_v.applies_to%TYPE;
2164: l_salesrep_id NUMBER;
2165: l_salesrep_name VARCHAR2 (1000);
2166:

Line 2163: l_applies_to oks_report_templates_v.applies_to%TYPE;

2159: l_api_name CONSTANT VARCHAR2 (30) := 'validate_autoreminder_k';
2160: l_item_key wf_items.item_key%TYPE := '';
2161: l_online_yn VARCHAR2 (1) := 'N';
2162: l_process_code oks_report_templates_v.process_code%TYPE;
2163: l_applies_to oks_report_templates_v.applies_to%TYPE;
2164: l_salesrep_id NUMBER;
2165: l_salesrep_name VARCHAR2 (1000);
2166:
2167: CURSOR csr_k_hdr_details IS