DBA Data[Home] [Help]

APPS.PER_KR_EXTRA_AEI_RULES dependencies on DUAL

Line 24: from dual

20: and pds.period_of_service_id = asg.period_of_service_id
21: for update of pds.period_of_service_id nowait;
22: cursor csr_unique is
23: select 'Y'
24: from dual
25: where not exists(
26: select null
27: from per_assignment_extra_info
28: where assignment_id = p_assignment_id

Line 1862: from dual;

1858: l_year number(4);
1859:
1860: cursor csr is
1861: select pay_kr_ff_functions_pkg.aged_flag(p_aei_information8,l_effective_date)
1862: from dual;
1863: --
1864: begin
1865: --
1866: if (p_information_type = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO') then