APPS.PAY_DK_TCR dependencies on DUAL

Line 140: SELECT to_char(sysdate,'yyyymmdd') INTO l_date FROM dual;

136: gtagdata(l_counter).TagValue := '1000';
137: l_counter := l_counter + 1;
138:
139: /*Date sent*/
140: SELECT to_char(sysdate,'yyyymmdd') INTO l_date FROM dual;
141: gtagdata(l_counter).TagName := 'RT1000_03';
142: gtagdata(l_counter).TagValue := l_date;
143: l_counter := l_counter + 1;
144:

Line 146: SELECT to_char(sysdate,'hhmiss') INTO l_time FROM dual;

142: gtagdata(l_counter).TagValue := l_date;
143: l_counter := l_counter + 1;
144:
145: /*Time sent*/
146: SELECT to_char(sysdate,'hhmiss') INTO l_time FROM dual;
147: gtagdata(l_counter).TagName := 'RT1000_04';
148: gtagdata(l_counter).TagValue := l_time;
149: l_counter := l_counter + 1;
150:

Line 450: select decode(mod(substr(l_cpr_number,10),2),0,'2','1') into l_sex from dual;

446: gtagdata(l_counter).TagValue := rg_csr_get_person_id.dob;
447: l_counter := l_counter + 1;
448:
449: -- Include a condition for checking M/F
450: select decode(mod(substr(l_cpr_number,10),2),0,'2','1') into l_sex from dual;
451: gtagdata(l_counter).TagName := 'RT8001_04';
452: gtagdata(l_counter).TagValue := l_sex;
453: l_counter := l_counter + 1;
454: