APPS.GHR_CPDF_CHECK3 dependencies on GHR_CPDF_CHECK

Line 1: PACKAGE BODY GHR_CPDF_CHECK3 AS

1: PACKAGE BODY GHR_CPDF_CHECK3 AS
2: /* $Header: ghcpdf03.pkb 120.21.12010000.2 2008/12/11 09:59:53 utokachi ship $ */
3:
4: max_per_diem number(5) := 1000;
5: min_basic_pay number(10,2);

Line 813: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 18',

809: -- 05-Aug-07 Raju 5132113 Added pay plans GP, GR to edits
810: --- ----------------------------------------------------------------------------------------------------------
811: IF ( p_effective_date < to_date('2004/01/11','yyyy/mm/dd') ) then
812: if p_pay_basis in ('PA', 'PH', 'PM', 'BW', 'WC') then
813: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 18',
814: p_pay_basis,
815: 'Maximum Basic Pay',
816: p_effective_date);
817: if max_basic_pay IS NOT NULL then

Line 855: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 56',

851: --
852: If ( p_to_pay_plan not in('GP','GR', 'AD') ) THEN
853:
854: if p_pay_basis in ('BW','PA', 'PD', 'PH', 'WC') then
855: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 56',
856: p_pay_basis,
857: 'Maximum Basic Pay',
858: p_effective_date);
859:

Line 860: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 56',

856: p_pay_basis,
857: 'Maximum Basic Pay',
858: p_effective_date);
859:
860: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 56',
861: p_pay_basis,
862: 'Minimum Basic Pay',
863: p_effective_date);
864:

Line 901: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 56',

897: End if; -- Check for Pay Plan AD
898: ELSE
899: If p_to_pay_plan not in('GP','GR', 'AD') THEN
900: if p_pay_basis in ('BW','PA', 'PD', 'PH', 'WC') and p_occ_code not in ('0602','0680') then
901: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 56',
902: p_pay_basis, 'Maximum Basic Pay', p_effective_date);
903:
904: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 56',
905: p_pay_basis,'Minimum Basic Pay', p_effective_date);

Line 904: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 56',

900: if p_pay_basis in ('BW','PA', 'PD', 'PH', 'WC') and p_occ_code not in ('0602','0680') then
901: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 56',
902: p_pay_basis, 'Maximum Basic Pay', p_effective_date);
903:
904: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 56',
905: p_pay_basis,'Minimum Basic Pay', p_effective_date);
906:
907: if ( max_basic_pay IS NOT NULL and min_basic_pay IS NOT NULL ) then
908: open c_fw_pay_plans;

Line 946: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 18',

942: if p_pay_basis = 'PD' and
943: (substr(p_agency_subelement,1,2) in ('CU','FD','FL','FY') or
944: p_agency_subelement in ('TRAJ','TR35')) then
945:
946: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 18',
947: p_pay_basis,
948: 'Maximum Basic Pay',
949: p_effective_date);
950: if max_basic_pay is NOT NULL then

Line 2915: end GHR_CPDF_CHECK3;

2911: END IF;
2912:
2913: end chk_pay_rate_determinant;
2914:
2915: end GHR_CPDF_CHECK3;