APPS.GMF_SUBLEDGER_PKG dependencies on GMF_PERIOD_STATUSES

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

527: SELECT curr.period_id, prev.period_id,
528: mthd.cost_mthd_code
529: INTO g_crev_curr_period_id, g_crev_prev_period_id,
530: g_crev_prev_cost_mthd
531: FROM gmf_period_statuses curr, gmf_period_statuses prev, cm_mthd_mst mthd
532: WHERE curr.legal_entity_id = g_legal_entity_id
533: AND curr.cost_type_id = g_cost_type_id
534: AND curr.calendar_code = g_crev_curr_calendar
535: AND curr.period_code = g_crev_curr_period

Line 1640: l_period_id gmf_period_statuses.period_id%TYPE;

1636: l_post_om VARCHAR2(1) := 0;
1637: l_post_pm VARCHAR2(1) := 0;
1638: l_post_pur VARCHAR2(1) := 0;
1639:
1640: l_period_id gmf_period_statuses.period_id%TYPE;
1641:
1642:
1643: BEGIN
1644:

Line 1723: FROM gmf_period_statuses prdsta

1719:
1720: BEGIN
1721: SELECT period_id
1722: INTO l_period_id
1723: FROM gmf_period_statuses prdsta
1724: WHERE
1725: prdsta.legal_entity_id = g_legal_entity_id
1726: AND prdsta.cost_type_id = g_cost_type_id
1727: AND p_posting_start_date between prdsta.start_date and prdsta.end_date

Line 1989: FROM gmf_period_statuses

1985:
1986: CURSOR c_stend(cp_period_id NUMBER)
1987: IS
1988: SELECT start_date, end_date
1989: FROM gmf_period_statuses
1990: WHERE period_id = cp_period_id
1991: ;
1992:
1993: lc_prior_stend_tmp c_stend%ROWTYPE;

Line 2004: FROM gmf_period_statuses

2000: CURSOR c_chk_consq_perd(cp_le_id number, cp_cost_type_id number,
2001: cp_prior_end_date DATE, cp_curr_start_date DATE)
2002: IS
2003: SELECT COUNT(1)
2004: FROM gmf_period_statuses
2005: WHERE legal_entity_id = cp_le_id
2006: -- AND cost_type_id = cp_cost_type_id
2007: AND start_date >= cp_prior_end_date
2008: AND end_date <= cp_curr_start_date

Line 2031: FROM gmf_period_statuses prdsta,

2027: p_period_end_date DATE
2028: )
2029: IS
2030: SELECT preprd.period_id
2031: FROM gmf_period_statuses prdsta,
2032: gmf_period_statuses preprd
2033: WHERE prdsta.legal_entity_id = p_legal_entity_id
2034: AND prdsta.cost_type_id = p_cost_type_id
2035: AND preprd.legal_entity_id = prdsta.legal_entity_id

Line 2032: gmf_period_statuses preprd

2028: )
2029: IS
2030: SELECT preprd.period_id
2031: FROM gmf_period_statuses prdsta,
2032: gmf_period_statuses preprd
2033: WHERE prdsta.legal_entity_id = p_legal_entity_id
2034: AND prdsta.cost_type_id = p_cost_type_id
2035: AND preprd.legal_entity_id = prdsta.legal_entity_id
2036: AND preprd.cost_type_id = prdsta.cost_type_id

Line 2054: gmf_period_statuses gps,

2050: 'F',1,'P',1, 0)),0) AS close_status
2051: FROM org_acct_periods oap,
2052: hr_organization_information hoi,
2053: mtl_parameters mp,
2054: gmf_period_statuses gps,
2055: gl_ledgers gl,
2056: gmf_period_balances gpb
2057: WHERE gps.period_id = p_period_id
2058: AND hoi.org_information2 = gps.legal_entity_id

Line 2213: gmf_period_statuses gps,

2209: INTO x_inv_fiscal_year,
2210: x_inv_period
2211: FROM org_acct_periods oap,
2212: hr_organization_information hoi,
2213: gmf_period_statuses gps,
2214: gl_ledgers gl
2215: WHERE gps.period_id = l_prior_period_id
2216: AND hoi.org_information2 = gps.legal_entity_id
2217: AND hoi.org_information1 = gl.ledger_id

Line 2358: FROM gmf_period_statuses

2354: */
2355: CURSOR c_cmsrc_info(cp_period_id number)
2356: IS
2357: SELECT start_date, end_date
2358: FROM gmf_period_statuses
2359: WHERE period_id = cp_period_id
2360: ;
2361:
2362: lc_cmcal_info c_cmsrc_info%ROWTYPE;

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

2612: SELECT curr.period_id, prev.period_id,
2613: mthd.cost_mthd_code
2614: INTO g_crev_curr_period_id, g_crev_prev_period_id,
2615: g_crev_prev_cost_mthd
2616: FROM gmf_period_statuses curr, gmf_period_statuses prev, cm_mthd_mst mthd
2617: WHERE curr.legal_entity_id = g_legal_entity_id
2618: AND curr.cost_type_id = g_cost_type_id
2619: AND curr.calendar_code = g_crev_curr_calendar
2620: AND curr.period_code = g_crev_curr_period