[Home] [Help]
797: -- Also note, must join with stop_ee_id, not p_element_entry_id.
798: begin
799: select 'Y'
800: into v_error_flag
801: from sys.dual
802: where exists (
803: select null
804: from pay_element_entries_f pee
805: where pee.assignment_id = p_assignment_id
908: include := TRUE;
909: begin
910: select null
911: into dummy
912: from sys.dual
913: where exists (
914: select null
915: from hr_assignment_set_amendments amd
916: where amd.assignment_set_id = asetid
924: hr_utility.set_location('hr_dynsql.setinfo',15);
925: begin
926: select null
927: into dummy
928: from sys.dual
929: where exists (
930: select null
931: from hr_assignment_set_amendments amd
932: where amd.assignment_set_id = asetid
978: cursor csr_locker (p_asg_id in number,
979: p_eff_date in date)
980: is
981: select 1 res
982: from sys.dual
983: where exists (
984: select /*+ index(AC2 PAY_ASSIGNMENT_ACTIONS_N51) */ null
985: from pay_action_classifications acl,
986: pay_assignment_actions ac2,
1033: cursor csr_locker (p_asg_id in number,
1034: p_eff_date in date)
1035: is
1036: select 1 res
1037: from sys.dual
1038: where exists (
1039: select null
1040: from pay_action_classifications acl,
1041: pay_assignment_actions ac2,
1086: cursor csr_locker (p_asg_id in number,
1087: p_eff_date in date)
1088: is
1089: select 1 res
1090: from sys.dual
1091: where exists (
1092: select null
1093: from pay_action_classifications acl,
1094: pay_assignment_actions ac2,
1138: cursor csr_locker (p_asg_id in number,
1139: p_eff_date in date)
1140: is
1141: select 1 res
1142: from sys.dual
1143: where exists (
1144: select null
1145: from pay_action_classifications acl,
1146: pay_assignment_actions ac2,
1156: cursor csr_ba_locker (p_asg_id in number,
1157: p_eff_date in date)
1158: is
1159: select 1 res
1160: from sys.dual
1161: where exists (
1162: select null
1163: from pay_action_classifications acl,
1164: pay_assignment_actions ac2,
1172: cursor csr_locker_fut (p_asg_id in number,
1173: p_eff_date in date)
1174: is
1175: select 1 res
1176: from sys.dual
1177: where exists (
1178: select null
1179: from pay_action_classifications acl,
1180: pay_assignment_actions ac2,
2000: -- If we are here then business group and legislation
2001: -- code should be known.
2002: select 1
2003: into l_dummy
2004: from dual
2005: where exists (
2006: select ''
2007: from hr_organization_units hou,
2008: hr_organization_information houi
2724: l_start_date date,
2725: l_end_date date
2726: ) is
2727: select 'Y'
2728: from dual
2729: where (NOT EXISTS
2730: (select null
2731: from pay_element_entry_values_f ev3,
2732: pay_input_values_f iv3