APPS.PAY_NL_RETRO_SETUP_REPORT dependencies on PAY_ELEMENT_TYPES_F

Line 48: pay_element_types_f pat

44: pec1.classification_name
45: FROM
46: pay_element_classifications pec ,
47: pay_element_classifications_tl pec1 ,
48: pay_element_types_f pat
49: WHERE
50: pec.legislation_code = 'NL'
51: AND pec.parent_classification_id IS NULL
52: AND pec1.language = USERENV('LANG') -- Bug ref. 5837256

Line 76: pay_element_types_f pat,

72: ptd2.definition_name Time_To ,
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,

Line 82: pay_element_types_f pat1,

78: pay_element_span_usages pesu,
79: pay_time_spans pts,
80: pay_time_definitions ptd1,
81: pay_time_definitions ptd2,
82: pay_element_types_f pat1,
83: pay_retro_components prc,
84: pay_element_classifications_tl pec
85:
86: WHERE

Line 108: pay_element_types_f pat,

104: CURSOR csr_get_ele_without_ret(c_bg_id NUMBER,c_eff_date DATE, c_class_id NUMBER) IS
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

Line 132: l_element_name pay_element_types_f.element_name%TYPE := ' ';

128: vCtr NUMBER := 0;
129: v_get_ele_class csr_get_ele_class%ROWTYPE;
130: v_get_ele_without_ret csr_get_ele_without_ret%ROWTYPE;
131: v_get_element_record csr_get_element_record%ROWTYPE;
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 := ' ';

Line 133: l_show_element pay_element_types_f.element_name%TYPE := ' ';

129: v_get_ele_class csr_get_ele_class%ROWTYPE;
130: v_get_ele_without_ret csr_get_ele_without_ret%ROWTYPE;
131: v_get_element_record csr_get_element_record%ROWTYPE;
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 := ' ';