DBA Data[Home] [Help]

APPS.PA_CUSTOMER_INFO dependencies on DUAL

Line 788: FROM dual

784: --start of addition for bug 5554475
785: BEGIN
786: SELECT 'Y'
787: INTO l_bill_to_contact_exists
788: FROM dual
789: WHERE EXISTS (SELECT 'Y'
790: FROM Pa_Project_Contacts
791: WHERE Project_Id = X_Project_Id
792: AND Customer_Id = X_Customer_Id

Line 803: FROM dual

799:
800: BEGIN
801: SELECT 'Y'
802: INTO l_ship_to_contact_exists
803: FROM dual
804: WHERE EXISTS (SELECT 'Y'
805: FROM Pa_Project_Contacts
806: WHERE Project_Id = X_Project_Id
807: AND Customer_Id = X_Customer_Id

Line 1093: FROM dual

1089: Function revenue_accrued_or_billed( p_project_Id In Number)
1090: return boolean IS
1091: CURSOR C IS
1092: SELECT 'x'
1093: FROM dual
1094: WHERE exists
1095: (select null
1096: from pa_draft_revenues r
1097: where r.project_id = p_project_Id