APPS.PAY_ASG_GEO_PKG dependencies on DUAL

Line 52: FROM dual

48: IF P_jurisdiction like '%000-0000' THEN
49: v_level := 'State';
50: SELECT 'Y'
51: INTO v_exists
52: FROM dual
53: WHERE EXISTS (
54: SELECT 'Y'
55: FROM pay_us_asg_reporting
56: WHERE assignment_id = P_assignment_id

Line 69: FROM dual

65: ELSIF P_jurisdiction like '%-0000' THEN
66: v_level := 'County';
67: SELECT 'Y'
68: INTO v_exists
69: FROM dual
70: WHERE EXISTS (
71: SELECT 'Y'
72: FROM pay_us_asg_reporting
73: WHERE assignment_id = P_assignment_id

Line 85: FROM dual

81: ELSIF length(P_jurisdiction) = 8 THEN
82: v_level := 'School';
83: SELECT 'Y'
84: INTO v_exists
85: FROM dual
86: WHERE EXISTS(
87: SELECT 'Y'
88: FROM pay_us_asg_reporting
89: WHERE assignment_id = P_assignment_id

Line 96: FROM dual

92: ELSE
93: v_level := 'City';
94: SELECT 'Y'
95: INTO v_exists
96: FROM dual
97: WHERE EXISTS(
98: SELECT 'Y'
99: FROM pay_us_asg_reporting
100: WHERE assignment_id = P_assignment_id