APPS.CSF_DEBRIEF_PVT dependencies on CSP_PLANNING_PARAMETERS

Line 3483: log('task_assignment_post_update','update csp_planning_parameters');

3479: log('task_assignment_post_update','l_travel_flag: '||l_travel_flag);
3480: log('task_assignment_post_update','l_working_flag: '||l_working_flag);
3481: close c_working_flag;
3482: if nvl(l_working_flag,'N') = 'Y' or nvl(l_travel_flag,'N') = 'Y' then
3483: log('task_assignment_post_update','update csp_planning_parameters');
3484: update csp_planning_parameters cpp
3485: set hz_location_id =
3486: (select hps.location_id
3487: from hz_party_sites hps,

Line 3484: update csp_planning_parameters cpp

3480: log('task_assignment_post_update','l_working_flag: '||l_working_flag);
3481: close c_working_flag;
3482: if nvl(l_working_flag,'N') = 'Y' or nvl(l_travel_flag,'N') = 'Y' then
3483: log('task_assignment_post_update','update csp_planning_parameters');
3484: update csp_planning_parameters cpp
3485: set hz_location_id =
3486: (select hps.location_id
3487: from hz_party_sites hps,
3488: jtf_tasks_b jtb,

Line 3506: log('task_assignment_post_update','update csp_planning_parameters in else');

3502: fetch c_any_working_task into l_any_working_task;
3503: log('task_assignment_post_update','l_any_working_task: '||l_any_working_task);
3504: close c_any_working_task;
3505: if l_any_working_task = 'N' then
3506: log('task_assignment_post_update','update csp_planning_parameters in else');
3507: update csp_planning_parameters cpp
3508: set hz_location_id =
3509: (select min(hps.location_id)
3510: from hz_party_sites hps, csp_rs_cust_relations crcr,

Line 3507: update csp_planning_parameters cpp

3503: log('task_assignment_post_update','l_any_working_task: '||l_any_working_task);
3504: close c_any_working_task;
3505: if l_any_working_task = 'N' then
3506: log('task_assignment_post_update','update csp_planning_parameters in else');
3507: update csp_planning_parameters cpp
3508: set hz_location_id =
3509: (select min(hps.location_id)
3510: from hz_party_sites hps, csp_rs_cust_relations crcr,
3511: hz_cust_acct_sites_all hcasa,hz_cust_site_uses_all hcsua