APPS.HRI_DBI_WMV_SEPARATION dependencies on HR_PTL_SUMMARY_DATA_S

Line 377: hr_ptl_summary_data_s.NEXTVAL,

373: sum_information3,
374: sum_information4,
375: sum_information5
376: ) VALUES (
377: hr_ptl_summary_data_s.NEXTVAL,
378: context_type,
379: p_supv_id,
380: p_eff_dt,
381: g_who_id,

Line 532: l_vol hr_ptl_summary_data.sum_information4%TYPE;

528: AND sum_information2 = cp_sup_id
529: AND sum_information3 = cp_sub_id;
530: --
531: l_rid ROWID;
532: l_vol hr_ptl_summary_data.sum_information4%TYPE;
533: l_invol hr_ptl_summary_data.sum_information5%TYPE;
534: --
535: BEGIN
536: --

Line 533: l_invol hr_ptl_summary_data.sum_information5%TYPE;

529: AND sum_information3 = cp_sub_id;
530: --
531: l_rid ROWID;
532: l_vol hr_ptl_summary_data.sum_information4%TYPE;
533: l_invol hr_ptl_summary_data.sum_information5%TYPE;
534: --
535: BEGIN
536: --
537: -- See if there's already a row for this supervisor/subordinate on this date