APPS.PQP_GB_PENSRV_SVPN dependencies on PQP_GB_PENSRV_SVPN

Line 1: PACKAGE BODY PQP_GB_PENSRV_SVPN AS

1: PACKAGE BODY PQP_GB_PENSRV_SVPN AS
2: /* $Header: pqpgbpsispn.pkb 120.4 2008/01/09 03:59:44 rlingama noship $ */
3:
4: -- Globals
5:

Line 81: AND paaf.effective_start_date = PQP_GB_PENSRV_SVPN.chk_emp_eligibility(paaf.assignment_id)

77: AND paaf.PRIMARY_FLAG = 'Y'
78: AND paaf.business_group_id = g_business_group_id
79: AND paaf.effective_start_date <= c_eff_end_date
80: AND paaf.effective_end_date >= g_eff_start_date
81: AND paaf.effective_start_date = PQP_GB_PENSRV_SVPN.chk_emp_eligibility(paaf.assignment_id)
82: ORDER BY papf.national_identifier,ppos.period_of_service_id;
83:
84: -- Cursor to fetch Maintain Service period Number flag
85:

Line 288: g_package_name := 'pqp_gb_pensrv_svpn';

284: RAISE;
285: END derive_svpn;
286:
287: BEGIN
288: g_package_name := 'pqp_gb_pensrv_svpn';
289: END pqp_gb_pensrv_svpn;
290:

Line 289: END pqp_gb_pensrv_svpn;

285: END derive_svpn;
286:
287: BEGIN
288: g_package_name := 'pqp_gb_pensrv_svpn';
289: END pqp_gb_pensrv_svpn;
290: