APPS.PSB_LD_POS_DEFAULTS_PVT dependencies on PSB_POSITIONS

Line 52: FROM PSB_POSITIONS

48: business_group_id,
49: vacant_position_flag,
50: effective_start_date,
51: effective_end_date
52: FROM PSB_POSITIONS
53: WHERE data_extract_id = p_data_extract_id
54: AND (vacant_position_flag is NULL
55: or vacant_position_flag = 'N');
56:

Line 60: FROM PSB_POSITIONS

56:
57: CURSOR l_dates_csr is
58: SELECT effective_start_date,
59: effective_END_date
60: FROM PSB_POSITIONS
61: WHERE position_id = l_position_id;
62:
63:
64: --to check what rules were already applied AND the total distribution