APPS.FII_PMV_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 73

     select ENT_PERIOD_ID into period_id from fii_time_ent_period where sysdate
between START_DATE and END_DATE;

Line: 102

FUNCTION get_display_currency(p_selected_operating_unit      IN VARCHAR2) RETURN VARCHAR2 IS
BEGIN
    IF g_sec_profile is null then
        g_sec_profile := nvl(fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL'), -1);

Line: 116

    IF(p_selected_operating_unit <> 'ALL') then
        IF (g_operating_unit is null or g_operating_unit <> p_selected_operating_unit) THEN
           g_operating_unit := p_selected_operating_unit;

Line: 120

  	   select currency_code
           into g_functional_currency_code
           from financials_system_params_all fsp,
                gl_ledgers_public_v gsob
           where fsp.org_id = p_selected_operating_unit
           and fsp.set_of_books_id = gsob.ledger_id;

Line: 140

           g_all_operating_unit := p_selected_operating_unit; ---gets set a value for the first run

Line: 142

           select distinct currency_code
           into g_common_functional_currency
           from financials_system_params_all fsp,
             gl_ledgers_public_v gsob
           where fsp.set_of_books_id = gsob.ledger_id
	AND (
		(
			g_det_ou_lov=1 AND fsp.org_id = fsp.org_id
		)
		OR (
			g_det_ou_lov=2
			AND fsp.org_id in (
				SELECT organization_id
				FROM hr_operating_units
				WHERE business_group_id = fii_pmv_util.g_business_group_id
			)
		)
		OR (
			g_det_ou_lov=3
			AND fsp.org_id in (
				SELECT organization_id
				FROM per_organization_list
				WHERE security_profile_id = g_sec_profile
			)
		)
		OR(
			g_det_ou_lov=4 AND fsp.org_id = nvl(fnd_profile.value('ORG_ID'), -1)
		)
	);

Line: 272

        p_table_name := '(select organization_id id, name value from hr_all_organization_units)';

Line: 275

        p_table_name := '(select id, value from POA_SUPPLIERS_V)';

Line: 312

    SELECT view_all_organizations_flag, business_group_id
    INTO l_all_org_flag, l_business_group_id
    FROM per_security_profiles
    WHERE security_profile_id = g_security_profile_id;

Line: 322

      		SELECT COUNT(1) INTO l_org_count
      		FROM hr_operating_units hr, ap_system_parameters_all ap
      		WHERE hr.business_group_id = l_business_group_id
      		AND hr.organization_id = ap.org_id;

Line: 329

      		p_org_where := ' and f.org_id in (select organization_id from hr_operating_units hr, ap_system_parameters_all ap where hr.business_group_id = :BUSINESS_GROUP and hr.organization_id = ap.org_id) ';

Line: 333

        	FOR C1_Rec in (select organization_id from hr_operating_units hr, ap_system_parameters_all ap where hr.business_group_id = l_business_group_id and hr.organization_id = ap.org_id)
		LOOP
        		l_org_list := l_org_list||C1_Rec.organization_id||',';

Line: 342

        	SELECT organization_id INTO l_org_id FROM hr_operating_units hr, ap_system_parameters_all ap WHERE hr.business_group_id = l_business_group_id AND hr.organization_id = ap.org_id;

Line: 353

      SELECT COUNT(1)
      INTO l_org_count
      FROM per_organization_list per, ap_system_parameters_all ap
      WHERE per.security_profile_id = g_security_profile_id
      AND per.organization_id = ap.org_id;

Line: 361

        	p_org_where := ' and f.org_id in (select organization_id from per_organization_list per, ap_system_parameters_all ap where per.security_profile_id = :SEC_ID and per.organization_id = ap.org_id) ';

Line: 365

        	FOR C1_Rec in (select organization_id from per_organization_list per, ap_system_parameters_all ap where per.security_profile_id = g_security_profile_id and   per.organization_id = ap.org_id)
		LOOP
         		l_org_list := l_org_list||C1_Rec.organization_id||',';

Line: 374

      		SELECT organization_id INTO l_org_id FROM per_organization_list per, ap_system_parameters_all ap WHERE security_profile_id = g_security_profile_id AND per.organization_id = ap.org_id;

Line: 710

             select (to_date(l_as_of_date,'DD-MM-YYYY') - start_date) into p_days_into_period from fii_time_week where week_id = p_cur_period;

Line: 715

             select (l_as_of_date - start_date) into p_days_into_period from fii_time_ent_period where ent_period_id = p_cur_period;

Line: 720

             select (l_as_of_date - start_date) into p_days_into_period from fii_time_ent_qtr where ent_qtr_id = p_cur_period;

Line: 725

             select (l_as_of_date - start_date) into p_days_into_period from fii_time_ent_year where ent_year_id = p_cur_period;

Line: 779

      select (l_as_of_date - start_date) into p_days_into_period from fii_time_week where week_id = p_cur_period;

Line: 781

      select (l_as_of_date - start_date) into p_days_into_period from fii_time_ent_period where ent_period_id = p_cur_period;

Line: 783

      select (l_as_of_date - start_date) into p_days_into_period from fii_time_ent_qtr where ent_qtr_id = p_cur_period;

Line: 785

      select (l_as_of_date - start_date) into p_days_into_period from fii_time_ent_year where ent_year_id = p_cur_period;

Line: 787

      select (l_as_of_date - start_date) into p_days_into_period from fii_time_ent_year where ent_year_id = p_cur_period;

Line: 816

             select week_id into p_cur_period from fii_time_day where report_date=l_as_of_date;

Line: 825

             select ent_period_id into p_cur_period from fii_time_day where report_date=l_as_of_date;

Line: 834

             select ent_qtr_id into p_cur_period from fii_time_day where report_date=l_as_of_date;

Line: 843

             select ent_year_id into p_cur_period from fii_time_day where report_date=l_as_of_date;

Line: 947

		SELECT view_all_organizations_flag, business_group_id
		INTO l_all_org_flag, l_business_group_id
		FROM per_security_profiles
		WHERE security_profile_id = g_security_profile_id;

Line: 975

	SELECT business_group_id
	INTO l_business_group_id
	FROM per_security_profiles
	WHERE security_profile_id = g_security_profile_id;