APPS.PAY_KR_YEA_PDF_PKG dependencies on DUAL

Line 791: from dual;

787: else
788: --
789: select per_kr_assignment_yea_info_s.nextval
790: into l_assignment_yea_info_id
791: from dual;
792: --
793: insert into per_kr_assignment_yea_info(
794: assignment_yea_info_id,
795: assignment_id,

Line 3377: from dual;

3373: end if;
3374: --
3375: select per_kr_assignment_yea_info_s.nextval
3376: into l_assignment_yea_info_id
3377: from dual;
3378: --
3379: insert into per_kr_assignment_yea_info(
3380: assignment_yea_info_id,
3381: assignment_id,

Line 3681: from dual

3677: --
3678: cursor csr_future_exists
3679: is
3680: select 'Y'
3681: from dual
3682: where exists(
3683: select null
3684: from per_contact_extra_info_f
3685: where contact_extra_info_id = p_contact_extra_info_id

Line 4599: select substr(l_lthouse_tbl(j02cnt).start_date,1,4) into l_start_dt from dual;

4595: if l_lthouse_tbl.count > 0 then
4596: --
4597: for j02cnt in l_lthouse_tbl.first..l_lthouse_tbl.last loop
4598: --
4599: select substr(l_lthouse_tbl(j02cnt).start_date,1,4) into l_start_dt from dual;
4600:
4601: IF l_start_dt < 2012 THEN
4602: if l_lthouse_tbl(j02cnt).key is not null then
4603: --