APPS.HR_WPM_UTIL dependencies on PER_SP_PLAN

Line 983: FROM per_sp_plan plans, per_sp_successor_in_plan succ

979: SELECT 'Y'
980: FROM DUAL
981: WHERE EXISTS (
982: SELECT NULL
983: FROM per_sp_plan plans, per_sp_successor_in_plan succ
984: WHERE plans.successee_id = p_person_id
985: AND succ.status = 'A'
986: AND plans.status = 'A'
987: AND plans.plan_type = 'EMP'

Line 997: FROM per_sp_plan plans, per_sp_successor_in_plan succ

993: SELECT 'Y'
994: FROM DUAL
995: WHERE EXISTS (
996: SELECT NULL
997: FROM per_sp_plan plans, per_sp_successor_in_plan succ
998: WHERE succ.successor_id = p_person_id
999: AND succ.status = 'A'
1000: AND plans.status = 'A'
1001: AND succ.plan_id = plans.plan_id

Line 1111: FROM per_sp_plan sp,

1107: 'AVG', NVL (AVG (readiness_pct), 0),
1108: 'MIN', NVL (MIN (readiness_pct), 0),
1109: 'MAX', NVL (MAX (readiness_pct), 0)
1110: ) average_readiness
1111: FROM per_sp_plan sp,
1112: per_sp_successor_in_plan ssp,
1113: per_sp_successee_details ssd,
1114: hr_organization_information bg,
1115: per_people_f ppf,

Line 1176: FROM per_sp_plan sp,

1172: 'AVG', NVL (AVG (readiness_pct), 0),
1173: 'MIN', NVL (MIN (readiness_pct), 0),
1174: 'MAX', NVL (MAX (readiness_pct), 0)
1175: ) average_readiness
1176: FROM per_sp_plan sp,
1177: per_sp_successor_in_plan ssp,
1178: per_sp_successee_details ssd,
1179: per_people_f ppf,
1180: per_assignments_f paf,