APPS.PAY_CORE_UPGRADE_PKG dependencies on DUAL

Line 810: from dual

806: --
807: begin
808: select ''
809: into l_dummy
810: from dual
811: where exists (select ''
812: from pay_payroll_actions ppa,
813: pay_assignment_actions paa
814: where paa.assignment_id = p_object_id

Line 1022: from dual

1018: --
1019: begin
1020: select ''
1021: into l_dummy
1022: from dual
1023: where exists (select ''
1024: from pay_payroll_actions ppa,
1025: pay_assignment_actions paa
1026: where paa.assignment_id = p_object_id

Line 1086: from dual

1082: --
1083: begin
1084: select ''
1085: into l_dummy
1086: from dual
1087: where exists (select ''
1088: from pay_payroll_actions ppa,
1089: pay_assignment_actions paa
1090: where paa.assignment_id = p_object_id

Line 1226: from dual

1222: --
1223: begin
1224: select ''
1225: into l_dummy
1226: from dual
1227: where exists (select ''
1228: from pay_latest_balances plb
1229: where plb.person_id = p_object_id
1230: );

Line 1313: from dual

1309: --
1310: begin
1311: select ''
1312: into l_dummy
1313: from dual
1314: where exists (select ''
1315: from pay_payroll_actions ppa,
1316: pay_assignment_actions paa
1317: where paa.assignment_id = p_object_id

Line 1595: from dual

1591: begin
1592: -- An assignment is qualified if it has a non-null people group id
1593: select ''
1594: into l_dummy
1595: from dual
1596: where exists (select ''
1597: from per_all_assignments_f asg
1598: where asg.assignment_id = p_object_id
1599: and asg.people_group_id is not null

Line 1801: from dual

1797: begin
1798: -- An assignment is qualified if it has a non-null people group id
1799: select ''
1800: into l_dummy
1801: from dual
1802: where exists (select ''
1803: from per_all_assignments_f asg
1804: where asg.assignment_id = p_object_id
1805: and asg.assignment_type = 'E'