859: l_dummy number;
860: l_last_payroll_dt date;
861: cursor csr_asg_act_exists is
862: select 1
863: from dual
864: where exists
865: (select null
866: from pay_assignment_actions
867: where assignment_id = p_assignment_id);
965: l_dummy number;
966: l_last_payroll_dt date;
967: cursor csr_asg_act_exists is
968: select 1
969: from dual
970: where exists
971: (select null
972: from pay_assignment_actions
973: where assignment_id = p_assignment_id);
1030: l_dummy number;
1031: l_last_payroll_dt date;
1032: cursor csr_asg_act_exists is
1033: select 1
1034: from dual
1035: where exists
1036: (select null
1037: from pay_assignment_actions
1038: where assignment_id = p_assignment_id);
1354: l_dummy number;
1355: --
1356: cursor csr_asg_act_exists is
1357: select 1
1358: from dual
1359: where exists
1360: (select null
1361: from pay_assignment_actions
1362: where assignment_id = p_assignment_id);