APPS.PQH_PSF_BUS dependencies on FND_SESSIONS

Line 1193: from per_all_assignments_f asn,FND_SESSIONS SS,

1189: l_person_id number;
1190: l_assignment_fte number(15,2):=0;
1191: CURSOR c_budgeted_fte(p_person_id number, p_position_id number) is
1192: select nvl(sum(nvl(value,1)),0)
1193: from per_all_assignments_f asn,FND_SESSIONS SS,
1194: per_assignment_budget_values_f abv, FND_SESSIONS SS2,
1195: per_assignment_status_types ast
1196: where abv.assignment_id(+) = asn.assignment_id
1197: and SS.SESSION_ID = USERENV('sessionid')

Line 1194: per_assignment_budget_values_f abv, FND_SESSIONS SS2,

1190: l_assignment_fte number(15,2):=0;
1191: CURSOR c_budgeted_fte(p_person_id number, p_position_id number) is
1192: select nvl(sum(nvl(value,1)),0)
1193: from per_all_assignments_f asn,FND_SESSIONS SS,
1194: per_assignment_budget_values_f abv, FND_SESSIONS SS2,
1195: per_assignment_status_types ast
1196: where abv.assignment_id(+) = asn.assignment_id
1197: and SS.SESSION_ID = USERENV('sessionid')
1198: and asn.EFFECTIVE_START_DATE <= SS.EFFECTIVE_DATE

Line 1212: from per_all_assignments_f asn,FND_SESSIONS SS,

1208: and ast.per_system_status <> 'TERM_ASSIGN';
1209:
1210: CURSOR c_budgeted_fte_ex_asg(p_person_id number, p_position_id number, p_ex_assignment_id number) is
1211: select nvl(sum(nvl(value,1)),0)
1212: from per_all_assignments_f asn,FND_SESSIONS SS,
1213: per_assignment_budget_values_f abv, FND_SESSIONS SS2,
1214: per_assignment_status_types ast
1215: where abv.assignment_id(+) = asn.assignment_id
1216: and SS.SESSION_ID = USERENV('sessionid')

Line 1213: per_assignment_budget_values_f abv, FND_SESSIONS SS2,

1209:
1210: CURSOR c_budgeted_fte_ex_asg(p_person_id number, p_position_id number, p_ex_assignment_id number) is
1211: select nvl(sum(nvl(value,1)),0)
1212: from per_all_assignments_f asn,FND_SESSIONS SS,
1213: per_assignment_budget_values_f abv, FND_SESSIONS SS2,
1214: per_assignment_status_types ast
1215: where abv.assignment_id(+) = asn.assignment_id
1216: and SS.SESSION_ID = USERENV('sessionid')
1217: and asn.EFFECTIVE_START_DATE <= SS.EFFECTIVE_DATE

Line 1283: from per_all_assignments_f asn,FND_SESSIONS SS,

1279: l_assignment_fte number(15,2);
1280:
1281: CURSOR c_budgeted_fte(p_assignment_id number) is
1282: select nvl(value,1)
1283: from per_all_assignments_f asn,FND_SESSIONS SS,
1284: per_assignment_budget_values_f abv, FND_SESSIONS SS2
1285: where abv.assignment_id(+) = asn.assignment_id
1286: and SS.SESSION_ID = USERENV('sessionid')
1287: and asn.EFFECTIVE_START_DATE <= SS.EFFECTIVE_DATE

Line 1284: per_assignment_budget_values_f abv, FND_SESSIONS SS2

1280:
1281: CURSOR c_budgeted_fte(p_assignment_id number) is
1282: select nvl(value,1)
1283: from per_all_assignments_f asn,FND_SESSIONS SS,
1284: per_assignment_budget_values_f abv, FND_SESSIONS SS2
1285: where abv.assignment_id(+) = asn.assignment_id
1286: and SS.SESSION_ID = USERENV('sessionid')
1287: and asn.EFFECTIVE_START_DATE <= SS.EFFECTIVE_DATE
1288: and asn.EFFECTIVE_END_DATE >= SS.EFFECTIVE_DATE