DBA Data[Home] [Help]

APPS.PQP_GB_PSI_FUNCTIONS dependencies on DUAL

Line 404: select 'Y' from dual

400: ,p_assignment_id NUMBER
401: ,p_element_type_id NUMBER
402: )
403: IS
404: select 'Y' from dual
405: where
406: (select pee.element_type_id
407: from pay_element_entries_f pee ,pay_element_links_f pel
408: where pee.element_link_id = pel.element_link_id

Line 451: from dual

447: )
448: IS
449:
450: select 'Y'
451: from dual
452: where
453: (select PPS.DATE_START -- DECODE(PER.CURRENT_EMPLOYEE_FLAG,'Y',PPS.DATE_START,NULL)
454: from per_all_people_f PER, per_periods_of_service PPS
455: where per.person_id = p_person_id

Line 466: select add_months(p_effective_date,-3) from dual

462: and NVL(pps.final_process_date,to_date('31/12/4712','DD/MM/YYYY'))
463: )
464: <=
465: (
466: select add_months(p_effective_date,-3) from dual
467: );
468:
469: FUNCTION check_debug
470: (p_business_group_id IN VARCHAR2 -- context