APPS.PAY_US_W2C_RPT dependencies on DUAL

Line 574: from dual;

570: if lv_report_type in ('W2C_PRE_PROCESS') then
571: /* Create an assignment action for this person */
572: select pay_assignment_actions_s.nextval
573: into ln_w2c_asg_action
574: from dual;
575: hr_utility.trace('New w2c Action = ' || ln_w2c_asg_action);
576:
577: /* Insert into pay_assignment_actions. */
578: hr_nonrun_asact.insact(ln_w2c_asg_action

Line 671: from dual;

667:
668: /* Create an assignment action for this person */
669: select pay_assignment_actions_s.nextval
670: into ln_w2c_asg_action
671: from dual;
672: hr_utility.trace('New w2c Action = ' || ln_w2c_asg_action);
673:
674: /* Insert into pay_assignment_actions. */
675: hr_nonrun_asact.insact(ln_w2c_asg_action

Line 853: select to_char(ld_end_date,'YYYY') into l_year from dual;

849: if ld_end_date > ld_session_date then
850: ld_session_date := ld_end_date;
851: end if;
852:
853: select to_char(ld_end_date,'YYYY') into l_year from dual;
854:
855: hr_utility.trace('Beginning of the sort_action cursor');
856: p_sql_string :=
857: 'select mt.rowid

Line 1754: 'A_PER_PREFIX' ) into l_w2c_fields_c.emp_name from dual;

1750:
1751: select l_first_name||decode(l_middle_name,null,' ',
1752: ' '||substr(l_middle_name,1,1)||' ') ||
1753: hr_us_w2_rep.get_per_item(p_asg_action_id,
1754: 'A_PER_PREFIX' ) into l_w2c_fields_c.emp_name from dual;
1755: exception when others then null;
1756: end ;*/
1757:
1758: --Now load the originally reported data.

Line 1806: 'A_PER_PREFIX' ) into l_w2c_fields_o.emp_name from dual;

1802:
1803: select l_first_name||decode(l_middle_name,null,' ',
1804: ' '||substr(l_middle_name,1,1)||' ') ||
1805: hr_us_w2_rep.get_per_item(p_prev_asg_action_id,
1806: 'A_PER_PREFIX' ) into l_w2c_fields_o.emp_name from dual;
1807: hr_utility.trace('EMP NAME2 ' ||l_w2c_fields_o.emp_name);
1808: exception when others then null;
1809: end ;*/
1810:

Line 2034: select decode(l_box14_boonmh_value_c,0,'-0-',l_box14_boonmh_value_c) into l_box14_tab(l_b14_total_count+1).box14_meaning_c from dual;

2030: IF NVL(l_box14_boonmh_value_c,0) <> NVL(l_box14_boonmh_value_o,0) then
2031:
2032: l_box14_tab(l_b14_total_count+1).box14_code_c := 'BOONMH';
2033:
2034: select decode(l_box14_boonmh_value_c,0,'-0-',l_box14_boonmh_value_c) into l_box14_tab(l_b14_total_count+1).box14_meaning_c from dual;
2035:
2036: hr_utility.trace('l_box14_tab(l_b14_total_count).box14_meaning_c '||l_box14_tab(l_b14_total_count+1).box14_meaning_c);
2037:
2038: select decode(l_box14_boonmh_value_o,0,'-0-',l_box14_boonmh_value_o) into l_box14_tab(l_b14_total_count+1).box14_meaning_o from dual;

Line 2038: select decode(l_box14_boonmh_value_o,0,'-0-',l_box14_boonmh_value_o) into l_box14_tab(l_b14_total_count+1).box14_meaning_o from dual;

2034: select decode(l_box14_boonmh_value_c,0,'-0-',l_box14_boonmh_value_c) into l_box14_tab(l_b14_total_count+1).box14_meaning_c from dual;
2035:
2036: hr_utility.trace('l_box14_tab(l_b14_total_count).box14_meaning_c '||l_box14_tab(l_b14_total_count+1).box14_meaning_c);
2037:
2038: select decode(l_box14_boonmh_value_o,0,'-0-',l_box14_boonmh_value_o) into l_box14_tab(l_b14_total_count+1).box14_meaning_o from dual;
2039:
2040: hr_utility.trace('l_box14_tab(l_b14_total_count).box14_meaning_o '||l_box14_tab(l_b14_total_count).box14_meaning_o);
2041:
2042: l_b14_total_count := l_box14_tab.count+1;

Line 3066: into lv_full_name from sys.dual;

3062:
3063: --p_error_msg := Null; --Devlopment in progress so overriding it
3064:
3065: select l_w2c_fields_c.emp_name||l_w2c_fields_c.last_name||' '||l_w2c_fields_c.emp_suffix
3066: into lv_full_name from sys.dual;
3067:
3068: IF p_error_msg IS NULL THEN
3069:
3070: hr_utility.trace('After get W2c data' );

Line 3863: from dual ;

3859:
3860: if (instr(TEMP_UTL,' ') > 0 and TEMP_UTL is not null) then
3861: select substrb(TEMP_UTL, 1, instr(TEMP_UTL,' ') - 1)
3862: into g_temp_dir
3863: from dual ;
3864: elsif (TEMP_UTL is not null) then
3865: g_temp_dir := TEMP_UTL;
3866: end if;
3867: