APPS.PJI_UTILS dependencies on PJI_ORG_EXTR_INFO

Line 1435: FROM pji_org_extr_info info,

1431: info.pa_curr_rep_period,
1432: info.gl_curr_rep_period,
1433: params.value
1434: INTO l_specific_pa_period, l_specific_gl_period, l_specific_ent_period
1435: FROM pji_org_extr_info info,
1436: pji_system_parameters params
1437: WHERE info.org_id = p_org_id
1438: AND params.name = 'PJI_PJP_ENT_CURR_REP_PERIOD';
1439: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 1470: FROM pji_org_extr_info info

1466:
1467: ELSE
1468: SELECT info.gl_calendar_id, info.pa_calendar_id
1469: INTO l_gl_calendar_id, l_pa_calendar_id
1470: FROM pji_org_extr_info info
1471: WHERE info.org_id = p_org_id;
1472:
1473: IF p_calendar_type = 'G' THEN
1474: l_calendar_id := l_gl_calendar_id;

Line 1875: FROM PJI_ORG_EXTR_INFO INFO,

1871: INTO
1872: l_sp_curr_rep_pa_period,
1873: l_sp_curr_rep_gl_period,
1874: l_sp_curr_rep_ent_period
1875: FROM PJI_ORG_EXTR_INFO INFO,
1876: PJI_SYSTEM_PARAMETERS PARAMS
1877: WHERE 1=1
1878: AND ORG_ID = NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO'),1,1),
1879: ' ',NULL,SUBSTR(USERENV('CLIENT_INFO'),1,10))),-99)

Line 1890: FROM PJI_ORG_EXTR_INFO INFO,

1886: l_sp_curr_rep_org_tbl,
1887: l_sp_curr_rep_pa_period_tbl,
1888: l_sp_curr_rep_gl_period_tbl,
1889: l_sp_curr_rep_ent_period_tbl
1890: FROM PJI_ORG_EXTR_INFO INFO,
1891: HR_ALL_ORGANIZATION_UNITS_VL ORG
1892: WHERE ORGANIZATION_ID = ORG_ID
1893: ORDER BY ORG.NAME;
1894: EXCEPTION WHEN NO_DATA_FOUND then