DBA Data[Home] [Help]

APPS.HR_PPVOL dependencies on PER_ALL_ASSIGNMENTS_F

Line 1021: from per_all_assignments_f

1017: p_date_of_birth=>sysdate-8000);
1018: --
1019: select assignment_id
1020: into assignment1
1021: from per_all_assignments_f
1022: where person_id = person;
1023: --
1024: -- Now add people with personal payment methods
1025: --

Line 1040: from per_all_assignments_f

1036: -- Get the employee's assignment_id
1037: --
1038: select assignment_id
1039: into assignment2
1040: from per_all_assignments_f
1041: where person_id = person;
1042: --
1043: -- Now insert the PPMs
1044: --

Line 1081: from per_all_assignments_f

1077: -- Get the employee's assignment_id
1078: --
1079: select assignment_id
1080: into assignment3
1081: from per_all_assignments_f
1082: where person_id = person;
1083: --
1084: -- Now insert the PPMs
1085: --

Line 1112: from per_all_assignments_f

1108: -- Get the employee's assignment_id
1109: --
1110: select assignment_id
1111: into assignment4
1112: from per_all_assignments_f
1113: where person_id = person;
1114: --
1115: -- Now insert the PPMs
1116: --

Line 1153: from per_all_assignments_f

1149: -- Get the employee's assignment_id
1150: --
1151: select assignment_id
1152: into assignment5
1153: from per_all_assignments_f
1154: where person_id = person;
1155: --
1156: -- Now insert the PPMs
1157: --

Line 1207: from per_all_assignments_f

1203: -- Get the employee's assignment_id
1204: --
1205: select assignment_id
1206: into assignment6
1207: from per_all_assignments_f
1208: where person_id = person;
1209: --
1210: -- Now insert the PPMs
1211: --