APPS.PAY_NL_RETRO_SETUP_REPORT dependencies on PAY_RETRO_COMPONENT_USAGES

Line 56: AND (EXISTS (SELECT NULL FROM pay_retro_component_usages prcu WHERE

52: AND pec1.language = USERENV('LANG') -- Bug ref. 5837256
53: AND pat.classification_id = pec.classification_id
54: AND pat.business_group_id = c_bg_id
55: AND pec1.classification_id = pat.classification_id
56: AND (EXISTS (SELECT NULL FROM pay_retro_component_usages prcu WHERE
57: pat.element_type_id = prcu.creator_id
58: AND prcu.creator_type = 'ET') OR c_ele_rec = 'A');
59:
60: -- Cursor for getting element retro setup records

Line 77: pay_retro_component_usages prcu,

73: pec.classification_name
74:
75: FROM
76: pay_element_types_f pat,
77: pay_retro_component_usages prcu,
78: pay_element_span_usages pesu,
79: pay_time_spans pts,
80: pay_time_definitions ptd1,
81: pay_time_definitions ptd2,

Line 109: pay_retro_component_usages prcu

105: SELECT DISTINCT
106: pat.element_name
107: FROM
108: pay_element_types_f pat,
109: pay_retro_component_usages prcu
110: WHERE
111: pat.business_group_id = c_bg_id
112: AND c_eff_date between pat.effective_start_date AND pat.effective_end_date
113: AND pat.classification_id = c_class_id

Line 136: l_default_comp pay_retro_component_usages.default_component%TYPE := ' ';

132: l_element_name pay_element_types_f.element_name%TYPE := ' ';
133: l_show_element pay_element_types_f.element_name%TYPE := ' ';
134: l_component pay_retro_components.component_name%TYPE := ' ';
135: l_show_component pay_retro_components.component_name%TYPE := ' ';
136: l_default_comp pay_retro_component_usages.default_component%TYPE := ' ';
137: l_replace_run pay_retro_component_usages.replace_run_flag%TYPE := ' ';
138: l_override_dates pay_retro_component_usages.use_override_dates%TYPE := ' ';
139: l_reprocess_type pay_retro_component_usages.reprocess_type%TYPE := ' ';
140: l_bg_name csr_bg_name%ROWTYPE;

Line 137: l_replace_run pay_retro_component_usages.replace_run_flag%TYPE := ' ';

133: l_show_element pay_element_types_f.element_name%TYPE := ' ';
134: l_component pay_retro_components.component_name%TYPE := ' ';
135: l_show_component pay_retro_components.component_name%TYPE := ' ';
136: l_default_comp pay_retro_component_usages.default_component%TYPE := ' ';
137: l_replace_run pay_retro_component_usages.replace_run_flag%TYPE := ' ';
138: l_override_dates pay_retro_component_usages.use_override_dates%TYPE := ' ';
139: l_reprocess_type pay_retro_component_usages.reprocess_type%TYPE := ' ';
140: l_bg_name csr_bg_name%ROWTYPE;
141: l_str VARCHAR2(7500);

Line 138: l_override_dates pay_retro_component_usages.use_override_dates%TYPE := ' ';

134: l_component pay_retro_components.component_name%TYPE := ' ';
135: l_show_component pay_retro_components.component_name%TYPE := ' ';
136: l_default_comp pay_retro_component_usages.default_component%TYPE := ' ';
137: l_replace_run pay_retro_component_usages.replace_run_flag%TYPE := ' ';
138: l_override_dates pay_retro_component_usages.use_override_dates%TYPE := ' ';
139: l_reprocess_type pay_retro_component_usages.reprocess_type%TYPE := ' ';
140: l_bg_name csr_bg_name%ROWTYPE;
141: l_str VARCHAR2(7500);
142: l_str1 varchar2(1000);

Line 139: l_reprocess_type pay_retro_component_usages.reprocess_type%TYPE := ' ';

135: l_show_component pay_retro_components.component_name%TYPE := ' ';
136: l_default_comp pay_retro_component_usages.default_component%TYPE := ' ';
137: l_replace_run pay_retro_component_usages.replace_run_flag%TYPE := ' ';
138: l_override_dates pay_retro_component_usages.use_override_dates%TYPE := ' ';
139: l_reprocess_type pay_retro_component_usages.reprocess_type%TYPE := ' ';
140: l_bg_name csr_bg_name%ROWTYPE;
141: l_str VARCHAR2(7500);
142: l_str1 varchar2(1000);
143: l_str2 varchar2(20);