APPS.PO_DOCUMENT_ACTION_PVT dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 1336: l_using_positions FINANCIALS_SYSTEM_PARAMETERS.use_positions_flag%TYPE;

1332: l_exc_msg VARCHAR2(2000);
1333: l_fail_msg VARCHAR2(2000);
1334:
1335: l_forwarding_mode PO_DOCUMENT_TYPES.forwarding_mode_code%TYPE;
1336: l_using_positions FINANCIALS_SYSTEM_PARAMETERS.use_positions_flag%TYPE;
1337: l_bus_group_id FINANCIALS_SYSTEM_PARAMETERS.business_group_id%TYPE;
1338: l_hr_xbg_profile VARCHAR2(1);
1339:
1340: -- Bug 5386007: Replaced hr_employees_current_v with base tables to

Line 1337: l_bus_group_id FINANCIALS_SYSTEM_PARAMETERS.business_group_id%TYPE;

1333: l_fail_msg VARCHAR2(2000);
1334:
1335: l_forwarding_mode PO_DOCUMENT_TYPES.forwarding_mode_code%TYPE;
1336: l_using_positions FINANCIALS_SYSTEM_PARAMETERS.use_positions_flag%TYPE;
1337: l_bus_group_id FINANCIALS_SYSTEM_PARAMETERS.business_group_id%TYPE;
1338: l_hr_xbg_profile VARCHAR2(1);
1339:
1340: -- Bug 5386007: Replaced hr_employees_current_v with base tables to
1341: -- improve performance

Line 1351: from financials_system_parameters fsp)

1347: per_assignment_status_types past,
1348: per_periods_of_service b
1349: WHERE a.person_id = p.person_id
1350: AND poeh.business_group_id in (select fsp.business_group_id
1351: from financials_system_parameters fsp)
1352: AND a.period_of_service_id = b.period_of_service_id
1353: AND a.primary_flag = 'Y'
1354: AND Trunc(SYSDATE) BETWEEN p.effective_start_date AND p.effective_end_date
1355: AND Trunc(SYSDATE) BETWEEN a.effective_start_date AND a.effective_end_date

Line 1417: from financials_system_parameters fsp)

1413: per_assignment_status_types past,
1414: per_periods_of_service b
1415: WHERE a.person_id = p.person_id
1416: AND poeh.business_group_id in (select fsp.business_group_id
1417: from financials_system_parameters fsp)
1418: AND a.period_of_service_id = b.period_of_service_id
1419: AND a.primary_flag = 'Y'
1420: AND Trunc(SYSDATE) BETWEEN p.effective_start_date AND p.effective_end_date
1421: AND Trunc(SYSDATE) BETWEEN a.effective_start_date AND a.effective_end_date

Line 1474: FROM financials_system_parameters fsp;

1470: d_progress := 15;
1471:
1472: SELECT NVL(fsp.use_positions_flag, 'N'), fsp.business_group_id
1473: INTO l_using_positions, l_bus_group_id
1474: FROM financials_system_parameters fsp;
1475:
1476: d_progress := 16;
1477: l_hr_xbg_profile := NVL(hr_general.get_xbg_profile, 'N');
1478: