APPS.PSP_UPGRADE_EFF_REPORTS dependencies on PAY_ELEMENT_SETS

Line 75: SELECT 1 from pay_element_sets

71: -- AND assignment.primary_flag = 'Y'
72: ;
73:
74: CURSOR element_set_alredy_exist_csr (p_element_set_name IN Varchar2) is
75: SELECT 1 from pay_element_sets
76: where ELEMENT_SET_NAME = p_element_set_name;
77:
78: CURSOR element_striped_by_bg_csr is
79: SELECT DISTINCT business_group_id

Line 382: hr_utility.trace(' Create Elements: pay_element_sets_pkg.insert_row');

378: OPEN effort_element_csr(l_business_group_id);
379: FETCH effort_element_csr BULK COLLECT into eff_element_rec.element_type_id;
380: CLOSE effort_element_csr;
381:
382: hr_utility.trace(' Create Elements: pay_element_sets_pkg.insert_row');
383:
384: l_rowid := null;
385: l_element_Set_id := null;
386: pay_element_sets_pkg.insert_row(l_rowid, l_element_Set_id, l_business_group_id, null, l_element_set_name,'C', 'LD Eff Reports Migration Set', null, null);

Line 386: pay_element_sets_pkg.insert_row(l_rowid, l_element_Set_id, l_business_group_id, null, l_element_set_name,'C', 'LD Eff Reports Migration Set', null, null);

382: hr_utility.trace(' Create Elements: pay_element_sets_pkg.insert_row');
383:
384: l_rowid := null;
385: l_element_Set_id := null;
386: pay_element_sets_pkg.insert_row(l_rowid, l_element_Set_id, l_business_group_id, null, l_element_set_name,'C', 'LD Eff Reports Migration Set', null, null);
387: if l_element_set_suffix_number = 1 then
388: l_element_Set_name := substr(l_element_Set_name,1,length(l_element_Set_name)) || l_element_set_suffix_number;
389: ELSE
390: l_element_Set_name := substr(l_element_Set_name,1,length(l_element_Set_name)-length(l_element_set_suffix_number-1)) || l_element_set_suffix_number ;