APPS.PO_DOCUMENT_ACTION_PVT dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 1345: l_using_positions FINANCIALS_SYSTEM_PARAMETERS.use_positions_flag%TYPE;

1341: l_exc_msg VARCHAR2(2000);
1342: l_fail_msg VARCHAR2(2000);
1343:
1344: l_forwarding_mode PO_DOCUMENT_TYPES.forwarding_mode_code%TYPE;
1345: l_using_positions FINANCIALS_SYSTEM_PARAMETERS.use_positions_flag%TYPE;
1346: l_bus_group_id FINANCIALS_SYSTEM_PARAMETERS.business_group_id%TYPE;
1347: l_hr_xbg_profile VARCHAR2(1);
1348:
1349: -- Bug 5386007: Replaced hr_employees_current_v with base tables to

Line 1346: l_bus_group_id FINANCIALS_SYSTEM_PARAMETERS.business_group_id%TYPE;

1342: l_fail_msg VARCHAR2(2000);
1343:
1344: l_forwarding_mode PO_DOCUMENT_TYPES.forwarding_mode_code%TYPE;
1345: l_using_positions FINANCIALS_SYSTEM_PARAMETERS.use_positions_flag%TYPE;
1346: l_bus_group_id FINANCIALS_SYSTEM_PARAMETERS.business_group_id%TYPE;
1347: l_hr_xbg_profile VARCHAR2(1);
1348:
1349: -- Bug 5386007: Replaced hr_employees_current_v with base tables to
1350: -- improve performance

Line 1361: from financials_system_parameters fsp)

1357: per_all_assignments_f a,
1358: per_assignment_status_types past
1359: WHERE a.person_id = p.person_id
1360: AND poeh.business_group_id in (select fsp.business_group_id
1361: from financials_system_parameters fsp)
1362: AND a.primary_flag = 'Y'
1363: AND Trunc(SYSDATE) BETWEEN p.effective_start_date AND p.effective_end_date
1364: AND Trunc(SYSDATE) BETWEEN a.effective_start_date AND a.effective_end_date
1365: AND (NVL(CURRENT_EMPLOYEE_FLAG,'N') = 'Y'

Line 1427: from financials_system_parameters fsp)

1423: per_all_assignments_f a,
1424: per_assignment_status_types past
1425: WHERE a.person_id = p.person_id
1426: AND poeh.business_group_id in (select fsp.business_group_id
1427: from financials_system_parameters fsp)
1428: AND a.primary_flag = 'Y'
1429: AND Trunc(SYSDATE) BETWEEN p.effective_start_date AND p.effective_end_date
1430: AND Trunc(SYSDATE) BETWEEN a.effective_start_date AND a.effective_end_date
1431: AND (NVL(CURRENT_EMPLOYEE_FLAG,'N') = 'Y'

Line 1483: FROM financials_system_parameters fsp;

1479: d_progress := 15;
1480:
1481: SELECT NVL(fsp.use_positions_flag, 'N'), fsp.business_group_id
1482: INTO l_using_positions, l_bus_group_id
1483: FROM financials_system_parameters fsp;
1484:
1485: d_progress := 16;
1486: l_hr_xbg_profile := NVL(hr_general.get_xbg_profile, 'N');
1487: