DBA Data[Home] [Help]

APPS.PA_CUSTOMER_INFO dependencies on DUAL

Line 779: FROM dual

775: --start of addition for bug 5554475
776: BEGIN
777: SELECT 'Y'
778: INTO l_bill_to_contact_exists
779: FROM dual
780: WHERE EXISTS (SELECT 'Y'
781: FROM Pa_Project_Contacts
782: WHERE Project_Id = X_Project_Id
783: AND Customer_Id = X_Customer_Id

Line 794: FROM dual

790:
791: BEGIN
792: SELECT 'Y'
793: INTO l_ship_to_contact_exists
794: FROM dual
795: WHERE EXISTS (SELECT 'Y'
796: FROM Pa_Project_Contacts
797: WHERE Project_Id = X_Project_Id
798: AND Customer_Id = X_Customer_Id

Line 1084: FROM dual

1080: Function revenue_accrued_or_billed( p_project_Id In Number)
1081: return boolean IS
1082: CURSOR C IS
1083: SELECT 'x'
1084: FROM dual
1085: WHERE exists
1086: (select null
1087: from pa_draft_revenues r
1088: where r.project_id = p_project_Id