[Home] [Help]
792: -- Also note, must join with stop_ee_id, not p_element_entry_id.
793: begin
794: select 'Y'
795: into v_error_flag
796: from sys.dual
797: where exists (
798: select null
799: from pay_element_entries_f pee
800: where pee.assignment_id = p_assignment_id
903: include := TRUE;
904: begin
905: select null
906: into dummy
907: from sys.dual
908: where exists (
909: select null
910: from hr_assignment_set_amendments amd
911: where amd.assignment_set_id = asetid
919: hr_utility.set_location('hr_dynsql.setinfo',15);
920: begin
921: select null
922: into dummy
923: from sys.dual
924: where exists (
925: select null
926: from hr_assignment_set_amendments amd
927: where amd.assignment_set_id = asetid
973: cursor csr_locker (p_asg_id in number,
974: p_eff_date in date)
975: is
976: select 1 res
977: from sys.dual
978: where exists (
979: select null
980: from pay_action_classifications acl,
981: pay_assignment_actions ac2,
1028: cursor csr_locker (p_asg_id in number,
1029: p_eff_date in date)
1030: is
1031: select 1 res
1032: from sys.dual
1033: where exists (
1034: select null
1035: from pay_action_classifications acl,
1036: pay_assignment_actions ac2,
1081: cursor csr_locker (p_asg_id in number,
1082: p_eff_date in date)
1083: is
1084: select 1 res
1085: from sys.dual
1086: where exists (
1087: select null
1088: from pay_action_classifications acl,
1089: pay_assignment_actions ac2,
1133: cursor csr_locker (p_asg_id in number,
1134: p_eff_date in date)
1135: is
1136: select 1 res
1137: from sys.dual
1138: where exists (
1139: select null
1140: from pay_action_classifications acl,
1141: pay_assignment_actions ac2,
1151: cursor csr_ba_locker (p_asg_id in number,
1152: p_eff_date in date)
1153: is
1154: select 1 res
1155: from sys.dual
1156: where exists (
1157: select null
1158: from pay_action_classifications acl,
1159: pay_assignment_actions ac2,
1167: cursor csr_locker_fut (p_asg_id in number,
1168: p_eff_date in date)
1169: is
1170: select 1 res
1171: from sys.dual
1172: where exists (
1173: select null
1174: from pay_action_classifications acl,
1175: pay_assignment_actions ac2,
1965: -- If we are here then business group and legislation
1966: -- code should be known.
1967: select 1
1968: into l_dummy
1969: from dual
1970: where exists (
1971: select ''
1972: from hr_organization_units hou,
1973: hr_organization_information houi
2666: l_start_date date,
2667: l_end_date date
2668: ) is
2669: select 'Y'
2670: from dual
2671: where (NOT EXISTS
2672: (select null
2673: from pay_element_entry_values_f ev3,
2674: pay_input_values_f iv3