APPS.PQH_EMPLOYMENT_CATEGORY dependencies on PQH_EMPLOYMENT_CATEGORY

Line 1: PACKAGE BODY pqh_employment_category AS

1: PACKAGE BODY pqh_employment_category AS
2: /* $Header: pqhuseeo.pkb 115.7 2003/11/17 11:39:33 nsanghal noship $*/
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' pqh_employment_category.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pqh_employment_category.'; -- Global package name
9: --
10: --
11: -- ----------------------------------------------------------------------------
12: -- |-------------------------< fetch_empl_categories >------------------------|

Line 32: where formula_name = 'PQH_EMPLOYMENT_CATEGORY'

28: --
29: cursor c_frml is
30: select formula_id
31: from ff_formulas_f
32: where formula_name = 'PQH_EMPLOYMENT_CATEGORY'
33: and business_group_id = p_business_group_id
34: and l_effective_date between effective_start_date and effective_end_date;
35: --
36: Begin

Line 204: END pqh_employment_category;

200: FETCH csr_pos_date_start INTO l_start_date;
201: CLOSE csr_pos_date_start;
202: RETURN l_start_date;
203: END;
204: END pqh_employment_category;