APPS.PQH_PSF_BUS dependencies on FND_SESSIONS

Line 1218: from per_all_assignments_f asn,FND_SESSIONS SS,

1214: l_person_id number;
1215: l_assignment_fte number(15,2):=0;
1216: CURSOR c_budgeted_fte(p_person_id number, p_position_id number) is
1217: select nvl(sum(nvl(value,1)),0)
1218: from per_all_assignments_f asn,FND_SESSIONS SS,
1219: per_assignment_budget_values_f abv, FND_SESSIONS SS2,
1220: per_assignment_status_types ast
1221: where abv.assignment_id(+) = asn.assignment_id
1222: and SS.SESSION_ID = USERENV('sessionid')

Line 1219: per_assignment_budget_values_f abv, FND_SESSIONS SS2,

1215: l_assignment_fte number(15,2):=0;
1216: CURSOR c_budgeted_fte(p_person_id number, p_position_id number) is
1217: select nvl(sum(nvl(value,1)),0)
1218: from per_all_assignments_f asn,FND_SESSIONS SS,
1219: per_assignment_budget_values_f abv, FND_SESSIONS SS2,
1220: per_assignment_status_types ast
1221: where abv.assignment_id(+) = asn.assignment_id
1222: and SS.SESSION_ID = USERENV('sessionid')
1223: and asn.EFFECTIVE_START_DATE <= SS.EFFECTIVE_DATE

Line 1237: from per_all_assignments_f asn,FND_SESSIONS SS,

1233: and ast.per_system_status <> 'TERM_ASSIGN';
1234:
1235: CURSOR c_budgeted_fte_ex_asg(p_person_id number, p_position_id number, p_ex_assignment_id number) is
1236: select nvl(sum(nvl(value,1)),0)
1237: from per_all_assignments_f asn,FND_SESSIONS SS,
1238: per_assignment_budget_values_f abv, FND_SESSIONS SS2,
1239: per_assignment_status_types ast
1240: where abv.assignment_id(+) = asn.assignment_id
1241: and SS.SESSION_ID = USERENV('sessionid')

Line 1238: per_assignment_budget_values_f abv, FND_SESSIONS SS2,

1234:
1235: CURSOR c_budgeted_fte_ex_asg(p_person_id number, p_position_id number, p_ex_assignment_id number) is
1236: select nvl(sum(nvl(value,1)),0)
1237: from per_all_assignments_f asn,FND_SESSIONS SS,
1238: per_assignment_budget_values_f abv, FND_SESSIONS SS2,
1239: per_assignment_status_types ast
1240: where abv.assignment_id(+) = asn.assignment_id
1241: and SS.SESSION_ID = USERENV('sessionid')
1242: and asn.EFFECTIVE_START_DATE <= SS.EFFECTIVE_DATE

Line 1308: from per_all_assignments_f asn,FND_SESSIONS SS,

1304: l_assignment_fte number(15,2);
1305:
1306: CURSOR c_budgeted_fte(p_assignment_id number) is
1307: select nvl(value,1)
1308: from per_all_assignments_f asn,FND_SESSIONS SS,
1309: per_assignment_budget_values_f abv, FND_SESSIONS SS2
1310: where abv.assignment_id(+) = asn.assignment_id
1311: and SS.SESSION_ID = USERENV('sessionid')
1312: and asn.EFFECTIVE_START_DATE <= SS.EFFECTIVE_DATE

Line 1309: per_assignment_budget_values_f abv, FND_SESSIONS SS2

1305:
1306: CURSOR c_budgeted_fte(p_assignment_id number) is
1307: select nvl(value,1)
1308: from per_all_assignments_f asn,FND_SESSIONS SS,
1309: per_assignment_budget_values_f abv, FND_SESSIONS SS2
1310: where abv.assignment_id(+) = asn.assignment_id
1311: and SS.SESSION_ID = USERENV('sessionid')
1312: and asn.EFFECTIVE_START_DATE <= SS.EFFECTIVE_DATE
1313: and asn.EFFECTIVE_END_DATE >= SS.EFFECTIVE_DATE