APPS.PER_ZA_WSP_ARCHIVE_PKG dependencies on DUAL

Line 700: select substr(l_index,16,15) into l_skills_pri_id from dual;

696: if l_count > 0 then
697: l_index := g_wsp_pri_final_tab.FIRST;
698: for i in 1..l_count
699: loop
700: select substr(l_index,16,15) into l_skills_pri_id from dual;
701:
702: hr_utility.set_location('l_skills_pri_id ' || l_skills_pri_id, 10);
703: --
704: for j in g_wsp_priority_tab.FIRST..g_wsp_priority_tab.LAST

Line 753: select substr(l_index,16,15) into l_skills_pri_id from dual;

749: l_index := g_atr_pri_final_tab.FIRST;
750: for i in 1..l_count
751: loop
752: hr_utility.set_location('Step 0', 20);
753: select substr(l_index,16,15) into l_skills_pri_id from dual;
754: hr_utility.set_location('l_skills_pri_id ' || l_skills_pri_id, 20);
755: for j in g_atr_priority_tab.FIRST..g_atr_priority_tab.LAST
756: loop
757: hr_utility.set_location('Step 1: g_atr_priority_tab : '||j, 20);

Line 2027: From dual;

2023: , 'bank_province' bank_province
2024: , 'sic_code' sic_code -- A(1).9 Main business activity
2025: , 'total_employement' tot_emp -- A(1).10 Total Employment
2026: , 'Tot Ann Payroll' tot_prev_ann_pay -- A(1).11 Total prev fin-year annual payroll
2027: From dual;
2028: */
2029: -- To fetch SDF details
2030: cursor csr_sdf_info(p_legal_entity_id in number) is
2031: select hoi.org_information1 sdf_name

Line 2704: from dual;

2700: hr_utility.set_location('Entering asgrec',10);
2701: -- create an assignment action for the primary assignment
2702: select pay_assignment_actions_s.nextval
2703: into lockingactid
2704: from dual;
2705:
2706: -- Insert assignment into pay_assignment_actions
2707: hr_nonrun_asact.insact
2708: (

Line 2725: from dual;

2721: hr_utility.set_location('Entering asgrec ',20);
2722: -- create an assignment action for the primary assignment
2723: select pay_assignment_actions_s.nextval
2724: into lockingactid
2725: from dual;
2726:
2727: -- Insert assignment into pay_assignment_actions
2728: hr_nonrun_asact.insact
2729: (

Line 2876: select rpad(p_legal_entity_id,15,0) into l_legal_entity_id from dual;

2872: l_legal_entity_id varchar2(30);
2873: begin
2874: l_proc := g_package ||'archive_wsp_data2';
2875: hr_utility.set_location('Entering '||l_proc,10);
2876: select rpad(p_legal_entity_id,15,0) into l_legal_entity_id from dual;
2877: l_index := l_legal_entity_id ||p_skills_pri_id;
2878:
2879: if g_wsp_pri_final_tab.exists(l_index) then
2880: hr_utility.set_location('skills_priority_name '||g_wsp_pri_final_tab(l_index).skills_priority_name,20);

Line 3114: select rpad(p_legal_entity_id,15,0) into l_legal_entity_id from dual;

3110: -- initialize the pl/sql table
3111: l_per_compt_pri_tab.delete;
3112: l_per_courses_pri_tab.delete;
3113: --
3114: select rpad(p_legal_entity_id,15,0) into l_legal_entity_id from dual;
3115: --
3116: hr_utility.set_location('l_legal_entity_id: '||l_legal_entity_id,10);
3117: hr_utility.set_location('assactid : '||assactid,10);
3118: hr_utility.set_location('p_person_id : '||p_person_id,10);

Line 3494: select rpad(p_legal_entity_id,15,0) into l_legal_entity_id from dual;

3490: --
3491: l_proc := g_package || 'archive_atr_data2';
3492: hr_utility.trace('Entering '||l_proc);
3493: --
3494: select rpad(p_legal_entity_id,15,0) into l_legal_entity_id from dual;
3495: l_index := l_legal_entity_id ||p_skills_pri_id;
3496: --
3497: hr_utility.set_location('g_atr_pri_final_tab.COUNT: '||g_atr_pri_final_tab.COUNT,10);
3498: hr_utility.set_location('l_index :' ||l_index,10);

Line 3653: select rpad(p_legal_entity_id,15,0) into l_legal_entity_id from dual;

3649: and puci.user_column_id = puc.user_column_id;
3650:
3651: --
3652: begin
3653: select rpad(p_legal_entity_id,15,0) into l_legal_entity_id from dual;
3654: l_proc := g_package || 'archive_atr_data';
3655: hr_utility.trace('Entering '||l_proc);
3656: hr_utility.set_location('l_legal_entity_id: '||l_legal_entity_id,10);
3657: hr_utility.set_location('assactid : '||assactid,10);