DBA Data[Home] [Help]

APPS.PJI_PMV_ENGINE dependencies on PA_IMPLEMENTATIONS_ALL

Line 1765: FROM pa_implementations_all paimp

1761: END IF;
1762: INSERT INTO PJI_PMV_ORG_DIM_TMP (ID, NAME)
1763: SELECT paimp.org_id
1764: , decode(p_View_By,'OU',org.name,'-1')
1765: FROM pa_implementations_all paimp
1766: , hr_all_organization_units_tl org
1767: WHERE 1=1
1768: AND org.language = USERENV('LANG')
1769: AND paimp.org_id = org.organization_id;

Line 1780: FROM pa_implementations_all paimp

1776: END IF;
1777: INSERT INTO PJI_PMV_ORG_DIM_TMP (ID, NAME)
1778: SELECT paimp.org_id
1779: , decode(p_View_By,'OU',org.name,'-1')
1780: FROM pa_implementations_all paimp
1781: , hr_all_organization_units_tl org
1782: , per_organization_list sec
1783: WHERE 1=1
1784: AND org.language = USERENV('LANG')