APPS.PER_ASSIGNMENTS_F_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 138: l_asg_rec per_all_assignments_f%rowtype;

134: l_proc varchar2(200):= 'PER_ASSIGNMENTS_F_PKG.INSERT_ROW';
135: --
136: /*
137: --WWBUG 2130950 Begin hrwf synchronization --tpapired
138: l_asg_rec per_all_assignments_f%rowtype;
139: cursor l_asg_cur is
140: select *
141: from per_all_assignments_f
142: where assignment_id = P_ASSIGNMENT_ID

Line 141: from per_all_assignments_f

137: --WWBUG 2130950 Begin hrwf synchronization --tpapired
138: l_asg_rec per_all_assignments_f%rowtype;
139: cursor l_asg_cur is
140: select *
141: from per_all_assignments_f
142: where assignment_id = P_ASSIGNMENT_ID
143: and effective_start_date = P_EFFECTIVE_START_DATE
144: and effective_end_date = P_EFFECTIVE_END_DATE;
145: --WWBUG 2130950 End hrwf synchronization -tpapired

Line 1217: l_asg_rec per_all_assignments_f%rowtype;

1213:
1214: --
1215: /*
1216: --WWBUG 2130950 Begin hrwf synchronization --tpapired
1217: l_asg_rec per_all_assignments_f%rowtype;
1218: cursor l_asg_cur is
1219: select *
1220: from per_all_assignments_f
1221: where assignment_id = P_ASSIGNMENT_ID

Line 1220: from per_all_assignments_f

1216: --WWBUG 2130950 Begin hrwf synchronization --tpapired
1217: l_asg_rec per_all_assignments_f%rowtype;
1218: cursor l_asg_cur is
1219: select *
1220: from per_all_assignments_f
1221: where assignment_id = P_ASSIGNMENT_ID
1222: and effective_start_date = P_EFFECTIVE_START_DATE
1223: and effective_end_date = P_EFFECTIVE_END_DATE;
1224: --WWBUG 2130950 End hrwf synchronization -tpapired

Line 1273: per_all_assignments_f paf

1269: l_vendor_site_id number default null;
1270:
1271: cursor po_cwk is
1272: select vendor_id,vendor_site_id from
1273: per_all_assignments_f paf
1274: where paf.assignment_id = p_assignment_id
1275: and nvl(p_session_date,sysdate) between paf.effective_start_date
1276: and paf.effective_end_date;
1277: --end code for bug 6961562