APPS.GMF_SUBLEDGER_PKG dependencies on GMF_PERIOD_STATUSES

Line 381: FROM gmf_period_statuses curr, gmf_period_statuses prev, cm_mthd_mst mthd

377: SELECT curr.period_id, prev.period_id,
378: mthd.cost_mthd_code
379: INTO g_crev_curr_period_id, g_crev_prev_period_id,
380: g_crev_prev_cost_mthd
381: FROM gmf_period_statuses curr, gmf_period_statuses prev, cm_mthd_mst mthd
382: WHERE curr.legal_entity_id = g_legal_entity_id
383: AND curr.cost_type_id = g_cost_type_id
384: AND curr.calendar_code = g_crev_curr_calendar
385: AND curr.period_code = g_crev_curr_period

Line 1162: l_period_id gmf_period_statuses.period_id%TYPE;

1158: l_post_om VARCHAR2(1) := 0;
1159: l_post_pm VARCHAR2(1) := 0;
1160: l_post_pur VARCHAR2(1) := 0;
1161:
1162: l_period_id gmf_period_statuses.period_id%TYPE;
1163:
1164:
1165: BEGIN
1166:

Line 1220: FROM gmf_period_statuses prdsta

1216:
1217: BEGIN
1218: SELECT period_id
1219: INTO l_period_id
1220: FROM gmf_period_statuses prdsta
1221: WHERE
1222: prdsta.legal_entity_id = g_legal_entity_id
1223: AND prdsta.cost_type_id = g_cost_type_id
1224: AND p_posting_start_date between prdsta.start_date and prdsta.end_date

Line 1470: FROM gmf_period_statuses

1466:
1467: CURSOR c_stend(cp_period_id NUMBER)
1468: IS
1469: SELECT start_date, end_date
1470: FROM gmf_period_statuses
1471: WHERE period_id = cp_period_id
1472: ;
1473:
1474: lc_prior_stend_tmp c_stend%ROWTYPE;

Line 1485: FROM gmf_period_statuses

1481: CURSOR c_chk_consq_perd(cp_le_id number, cp_cost_type_id number,
1482: cp_prior_end_date DATE, cp_curr_start_date DATE)
1483: IS
1484: SELECT COUNT(1)
1485: FROM gmf_period_statuses
1486: WHERE legal_entity_id = cp_le_id
1487: -- AND cost_type_id = cp_cost_type_id
1488: AND start_date >= cp_prior_end_date
1489: AND end_date <= cp_curr_start_date

Line 1511: FROM gmf_period_statuses prdsta,

1507: p_period_end_date DATE
1508: )
1509: IS
1510: SELECT preprd.period_id
1511: FROM gmf_period_statuses prdsta,
1512: gmf_period_statuses preprd
1513: WHERE prdsta.legal_entity_id = p_legal_entity_id
1514: AND prdsta.cost_type_id = p_cost_type_id
1515: AND preprd.legal_entity_id = prdsta.legal_entity_id

Line 1512: gmf_period_statuses preprd

1508: )
1509: IS
1510: SELECT preprd.period_id
1511: FROM gmf_period_statuses prdsta,
1512: gmf_period_statuses preprd
1513: WHERE prdsta.legal_entity_id = p_legal_entity_id
1514: AND prdsta.cost_type_id = p_cost_type_id
1515: AND preprd.legal_entity_id = prdsta.legal_entity_id
1516: AND preprd.cost_type_id = prdsta.cost_type_id

Line 1531: gmf_period_statuses gps,

1527: SELECT nvl(SUM(decode(nvl(gpb.period_close_status,'~'),'F',1,'P',1, 0)),0) as close_status
1528: FROM org_acct_periods oap,
1529: hr_organization_information hoi,
1530: mtl_parameters mp,
1531: gmf_period_statuses gps,
1532: gl_ledgers gl,
1533: gmf_period_balances gpb
1534: WHERE gps.period_id = p_period_id
1535: AND hoi.org_information2 = gps.legal_entity_id

Line 1690: gmf_period_statuses gps,

1686: INTO x_inv_fiscal_year,
1687: x_inv_period
1688: FROM org_acct_periods oap,
1689: hr_organization_information hoi,
1690: gmf_period_statuses gps,
1691: gl_ledgers gl
1692: WHERE gps.period_id = l_prior_period_id
1693: AND hoi.org_information2 = gps.legal_entity_id
1694: AND hoi.org_information1 = gl.ledger_id

Line 1835: FROM gmf_period_statuses

1831: */
1832: CURSOR c_cmsrc_info(cp_period_id number)
1833: IS
1834: SELECT start_date, end_date
1835: FROM gmf_period_statuses
1836: WHERE period_id = cp_period_id
1837: ;
1838:
1839: lc_cmcal_info c_cmsrc_info%ROWTYPE;

Line 2093: FROM gmf_period_statuses curr, gmf_period_statuses prev, cm_mthd_mst mthd

2089: SELECT curr.period_id, prev.period_id,
2090: mthd.cost_mthd_code
2091: INTO g_crev_curr_period_id, g_crev_prev_period_id,
2092: g_crev_prev_cost_mthd
2093: FROM gmf_period_statuses curr, gmf_period_statuses prev, cm_mthd_mst mthd
2094: WHERE curr.legal_entity_id = g_legal_entity_id
2095: AND curr.cost_type_id = g_cost_type_id
2096: AND curr.calendar_code = g_crev_curr_calendar
2097: AND curr.period_code = g_crev_curr_period