eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NL_RETRO_SETUP_REPORT dependencies on HR_GENERAL

Line 66: hr_general.decode_lookup('HR_NL_YES_NO',NVL(prcu.default_component,'N')) default_component,

62:
63: SELECT
64: pat.element_name,
65: prc.component_name,
66: hr_general.decode_lookup('HR_NL_YES_NO',NVL(prcu.default_component,'N')) default_component,
67: hr_general.decode_lookup('RETRO_REPROCESS_TYPE',prcu.reprocess_type) reprocess_type,
68: hr_general.decode_lookup('HR_NL_YES_NO',NVL(prcu.replace_run_flag,'N')) replace_run_flag,
69: hr_general.decode_lookup('HR_NL_YES_NO',NVL(prcu.use_override_dates,'N')) use_override_dates,
70: pat1.element_name Retro_Element,

Line 67: hr_general.decode_lookup('RETRO_REPROCESS_TYPE',prcu.reprocess_type) reprocess_type,

63: SELECT
64: pat.element_name,
65: prc.component_name,
66: hr_general.decode_lookup('HR_NL_YES_NO',NVL(prcu.default_component,'N')) default_component,
67: hr_general.decode_lookup('RETRO_REPROCESS_TYPE',prcu.reprocess_type) reprocess_type,
68: hr_general.decode_lookup('HR_NL_YES_NO',NVL(prcu.replace_run_flag,'N')) replace_run_flag,
69: hr_general.decode_lookup('HR_NL_YES_NO',NVL(prcu.use_override_dates,'N')) use_override_dates,
70: pat1.element_name Retro_Element,
71: ptd1.definition_name Time_from ,

Line 68: hr_general.decode_lookup('HR_NL_YES_NO',NVL(prcu.replace_run_flag,'N')) replace_run_flag,

64: pat.element_name,
65: prc.component_name,
66: hr_general.decode_lookup('HR_NL_YES_NO',NVL(prcu.default_component,'N')) default_component,
67: hr_general.decode_lookup('RETRO_REPROCESS_TYPE',prcu.reprocess_type) reprocess_type,
68: hr_general.decode_lookup('HR_NL_YES_NO',NVL(prcu.replace_run_flag,'N')) replace_run_flag,
69: hr_general.decode_lookup('HR_NL_YES_NO',NVL(prcu.use_override_dates,'N')) use_override_dates,
70: pat1.element_name Retro_Element,
71: ptd1.definition_name Time_from ,
72: ptd2.definition_name Time_To ,

Line 69: hr_general.decode_lookup('HR_NL_YES_NO',NVL(prcu.use_override_dates,'N')) use_override_dates,

65: prc.component_name,
66: hr_general.decode_lookup('HR_NL_YES_NO',NVL(prcu.default_component,'N')) default_component,
67: hr_general.decode_lookup('RETRO_REPROCESS_TYPE',prcu.reprocess_type) reprocess_type,
68: hr_general.decode_lookup('HR_NL_YES_NO',NVL(prcu.replace_run_flag,'N')) replace_run_flag,
69: hr_general.decode_lookup('HR_NL_YES_NO',NVL(prcu.use_override_dates,'N')) use_override_dates,
70: pat1.element_name Retro_Element,
71: ptd1.definition_name Time_from ,
72: ptd2.definition_name Time_To ,
73: pec.classification_name

Line 125: AND c_eff_date BETWEEN date_from AND NVL(date_to,hr_general.end_of_time);

121: CURSOR csr_bg_name(c_bg_id per_business_groups.name%TYPE, c_eff_date DATE) IS
122:
123: SELECT name FROM per_business_groups
124: WHERE business_group_id = c_bg_id
125: AND c_eff_date BETWEEN date_from AND NVL(date_to,hr_general.end_of_time);
126:
127: -- Local Variables
128: vCtr NUMBER := 0;
129: v_get_ele_class csr_get_ele_class%ROWTYPE;

Line 182: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := hr_general.decode_lookup('HR_NL_ESR_ELE_REC',p_ele_records);

178: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_bg_name.name;
179: vCtr := vCtr + 1;
180:
181: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ELE_RECORDS';
182: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := hr_general.decode_lookup('HR_NL_ESR_ELE_REC',p_ele_records);
183: vCtr := vCtr + 1;
184:
185: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||to_char(l_effec_date),600);
186: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||l_bg_name.name,620);

Line 187: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||hr_general.decode_lookup('HR_NL_ESR_ELE_REC',p_ele_records),640);

183: vCtr := vCtr + 1;
184:
185: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||to_char(l_effec_date),600);
186: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||l_bg_name.name,620);
187: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||hr_general.decode_lookup('HR_NL_ESR_ELE_REC',p_ele_records),640);
188:
189: -- Setting PL/SQL table for tags and values of the xml data for all the element records
190:
191: FOR v_get_ele_class IN csr_get_ele_class(p_business_group_id,p_ele_records)