APPS.PA_UTILS4 dependencies on DUAL

Line 26: FROM dual

22:
23: IF p_project_id is NOT NULL AND p_task_id is NOT NULL Then
24: SELECT 'Y'
25: INTO l_CC_txn_Exists
26: FROM dual
27: WHERE EXISTS (
28: SELECT 'CC TXNS'
29: FROM igc_cc_acct_lines igc
30: ,pa_projects_all pp

Line 45: FROM dual

41: ElsIF p_project_id is NOT NULL AND p_task_id is NULL Then
42:
43: SELECT 'Y'
44: INTO l_CC_txn_Exists
45: FROM dual
46: WHERE EXISTS (
47: SELECT 'CC TXNS'
48: FROM igc_cc_acct_lines igc
49: ,pa_projects_all pp

Line 655: FROM dual;

651: IF PA_UTILS4.G_WORKTYPE_ENABLED is NULL then
652:
653: SELECT nvl(fnd_profile.value_specific('PA_EN_NEW_WORK_TYPE_PROCESS'),'N')
654: INTO l_enabled_flag
655: FROM dual;
656: PA_UTILS4.G_WORKTYPE_ENABLED := l_enabled_flag;
657: print_msg('Executing query to get profile G_WORKTYPE_ENABLED['||PA_UTILS4.G_WORKTYPE_ENABLED||']' );
658:
659: End If;

Line 694: FROM dual;

690: IF PA_UTILS4.G_WORKTYPE_BILLABILITY is NULL then
691:
692: SELECT nvl(fnd_profile.value_specific('PA_TRXN_BILLABLE_WORK_TYPE'),'N')
693: INTO l_enabled_flag
694: FROM dual;
695: PA_UTILS4.G_WORKTYPE_BILLABILITY := l_enabled_flag;
696: print_msg('Executing query to get profile G_WORKTYPE_BILLABILITY: ['
697: ||PA_UTILS4.G_WORKTYPE_BILLABILITY||']' );
698: End If;

Line 971: FROM sys.dual

967: RETURN BOOLEAN IS
968:
969: CURSOR c1 IS
970: SELECT 'X'
971: FROM sys.dual
972: WHERE EXISTS ( SELECT 'x'
973: FROM pa_org_labor_sch_rule a
974: WHERE (a.cost_rate_sch_id = p_bill_rate_sch_id
975: OR

Line 983: FROM sys.dual

979: /* Bug # 3613754 In ISUSEDINCOSTING Function, splitted the cursor in two cursor */
980:
981: Cursor C2 Is
982: SELECT 'X'
983: FROM sys.dual
984: WHERE EXISTS ( SELECT 'y'
985: FROM pa_compensation_details_all b
986: WHERE b.rate_schedule_id = p_bill_rate_sch_id
987: ) ;

Line 1032: FROM dual;

1028: If p_reference1 IS Not Null Then
1029:
1030: SELECT TO_NUMBER(p_reference1)
1031: INTO l_return_number
1032: FROM dual;
1033:
1034: End If;
1035:
1036: Return l_return_number;