APPS.PER_ZA_WSP_ARCHIVE_PKG dependencies on DUAL

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

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

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

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

Line 2029: From dual;

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

Line 2710: from dual;

2706: hr_utility.set_location('Entering asgrec',10);
2707: -- create an assignment action for the primary assignment
2708: select pay_assignment_actions_s.nextval
2709: into lockingactid
2710: from dual;
2711:
2712: -- Insert assignment into pay_assignment_actions
2713: hr_nonrun_asact.insact
2714: (

Line 2731: from dual;

2727: hr_utility.set_location('Entering asgrec ',20);
2728: -- create an assignment action for the primary assignment
2729: select pay_assignment_actions_s.nextval
2730: into lockingactid
2731: from dual;
2732:
2733: -- Insert assignment into pay_assignment_actions
2734: hr_nonrun_asact.insact
2735: (

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

2878: l_legal_entity_id varchar2(30);
2879: begin
2880: l_proc := g_package ||'archive_wsp_data2';
2881: hr_utility.set_location('Entering '||l_proc,10);
2882: select rpad(p_legal_entity_id,15,0) into l_legal_entity_id from dual;
2883: l_index := l_legal_entity_id ||p_skills_pri_id;
2884:
2885: if g_wsp_pri_final_tab.exists(l_index) then
2886: hr_utility.set_location('skills_priority_name '||g_wsp_pri_final_tab(l_index).skills_priority_name,20);

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

3116: -- initialize the pl/sql table
3117: l_per_compt_pri_tab.delete;
3118: l_per_courses_pri_tab.delete;
3119: --
3120: select rpad(p_legal_entity_id,15,0) into l_legal_entity_id from dual;
3121: --
3122: hr_utility.set_location('l_legal_entity_id: '||l_legal_entity_id,10);
3123: hr_utility.set_location('assactid : '||assactid,10);
3124: hr_utility.set_location('p_person_id : '||p_person_id,10);

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

3496: --
3497: l_proc := g_package || 'archive_atr_data2';
3498: hr_utility.trace('Entering '||l_proc);
3499: --
3500: select rpad(p_legal_entity_id,15,0) into l_legal_entity_id from dual;
3501: l_index := l_legal_entity_id ||p_skills_pri_id;
3502: --
3503: hr_utility.set_location('g_atr_pri_final_tab.COUNT: '||g_atr_pri_final_tab.COUNT,10);
3504: hr_utility.set_location('l_index :' ||l_index,10);

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

3655: and puci.user_column_id = puc.user_column_id;
3656:
3657: --
3658: begin
3659: select rpad(p_legal_entity_id,15,0) into l_legal_entity_id from dual;
3660: l_proc := g_package || 'archive_atr_data';
3661: hr_utility.trace('Entering '||l_proc);
3662: hr_utility.set_location('l_legal_entity_id: '||l_legal_entity_id,10);
3663: hr_utility.set_location('assactid : '||assactid,10);