APPS.CN_PAYGROUP_PVT dependencies on DUAL

Line 50: FROM dual;

46: x_status := 'NEW PAY GROUP';
47: x_pay_group_id := l_get_PayGroup_id_rec.pay_group_id;
48: SELECT cn_pay_groups_s.nextval
49: INTO x_pay_group_id
50: FROM dual;
51: ELSIF get_PayGroup_id%ROWCOUNT = 1
52: THEN
53: x_status := 'PAY GROUP EXISTS';
54: x_pay_group_id := l_get_PayGroup_id_rec.pay_group_id;

Line 399: SELECT 1 INTO l_dummy FROM dual

395: -- Date 25-OCT-2000
396: --***********************************************************************
397:
398: BEGIN
399: SELECT 1 INTO l_dummy FROM dual
400: WHERE NOT EXISTS
401: ( SELECT 1
402: FROM cn_pay_groups
403: WHERE

Line 876: SELECT 1 INTO l_dummy FROM dual

872: -- Added Kumar
873: -- Date 25-OCT-2000
874: --***********************************************************************
875: BEGIN
876: SELECT 1 INTO l_dummy FROM dual
877: WHERE NOT EXISTS
878: ( SELECT 1
879: FROM cn_pay_groups
880: WHERE

Line 1039: select 1 into l_valid_data from dual where exists

1035: ELSE
1036: l_period_type_id := cn_api.g_miss_id;
1037: END IF;
1038:
1039: select 1 into l_valid_data from dual where exists
1040: (select count(cp.pay_date) from
1041: cn_srp_pay_groups cspg,cn_payment_worksheets cpw,cn_payruns cp
1042: where
1043: cp.payrun_id = cpw.payrun_id and cp.pay_group_id = cspg.pay_group_id and

Line 1087: SELECT 1 INTO l_dummy FROM dual

1083:
1084: IF p_old_PayGroup_rec.period_type <> p_PayGroup_rec.period_type or
1085: p_old_PayGroup_rec.period_set_name <> p_payGroup_Rec.period_set_name THEN
1086: BEGIN
1087: SELECT 1 INTO l_dummy FROM dual
1088: WHERE NOT EXISTS
1089: ( SELECT 1
1090: FROM cn_pay_groups pg,
1091: cn_payruns p

Line 1122: SELECT 1 INTO l_dummy FROM dual

1118: END;
1119:
1120:
1121: BEGIN
1122: SELECT 1 INTO l_dummy FROM dual
1123: WHERE NOT EXISTS
1124: ( SELECT 1
1125: FROM cn_srp_periods csp,
1126: cn_posting_details_sum cpd,