eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

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.26 2011/02/14 10:35:28 utokachi ship $ */
3:
4: max_per_diem number(5) := 1000;
5: min_basic_pay number(10,2);

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

864: -- 05-Aug-07 Raju 5132113 Added pay plans GP, GR to edits
865: --- ----------------------------------------------------------------------------------------------------------
866: IF ( p_effective_date < to_date('2004/01/11','yyyy/mm/dd') ) then
867: if p_pay_basis in ('PA', 'PH', 'PM', 'BW', 'WC') then
868: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 18',
869: p_pay_basis,
870: 'Maximum Basic Pay',
871: p_effective_date);
872: if max_basic_pay IS NOT NULL then

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

906: --
907: If ( p_to_pay_plan not in('GP','GR', 'AD') ) THEN
908:
909: if p_pay_basis in ('BW','PA', 'PD', 'PH', 'WC') then
910: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 56',
911: p_pay_basis,
912: 'Maximum Basic Pay',
913: p_effective_date);
914:

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

911: p_pay_basis,
912: 'Maximum Basic Pay',
913: p_effective_date);
914:
915: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 56',
916: p_pay_basis,
917: 'Minimum Basic Pay',
918: p_effective_date);
919:

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

952: End if; -- Check for Pay Plan AD
953: ELSIF ( p_effective_date < to_date('2011/02/01','yyyy/mm/dd') ) then -- bug 11726461
954: If p_to_pay_plan not in('GP','GR', 'AD') THEN
955: if p_pay_basis in ('BW','PA', 'PD', 'PH', 'WC') and p_occ_code not in ('0602','0680') then
956: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 56',
957: p_pay_basis, 'Maximum Basic Pay', p_effective_date);
958:
959: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 56',
960: p_pay_basis,'Minimum Basic Pay', p_effective_date);

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

955: if p_pay_basis in ('BW','PA', 'PD', 'PH', 'WC') and p_occ_code not in ('0602','0680') then
956: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 56',
957: p_pay_basis, 'Maximum Basic Pay', p_effective_date);
958:
959: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 56',
960: p_pay_basis,'Minimum Basic Pay', p_effective_date);
961:
962: if ( max_basic_pay IS NOT NULL and min_basic_pay IS NOT NULL ) then
963: open c_fw_pay_plans;

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

982: End if; -- Check for Pay Plan AD
983: ELSE --Begin Bug 11726461 added PM
984: If p_to_pay_plan not in('GP','GR', 'AD') THEN
985: if p_pay_basis in ('BW','PA', 'PD', 'PH', 'PM', 'WC') and p_occ_code not in ('0602','0680') then
986: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 56',
987: p_pay_basis, 'Maximum Basic Pay', p_effective_date);
988:
989: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 56',
990: p_pay_basis,'Minimum Basic Pay', p_effective_date);

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

985: if p_pay_basis in ('BW','PA', 'PD', 'PH', 'PM', 'WC') and p_occ_code not in ('0602','0680') then
986: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 56',
987: p_pay_basis, 'Maximum Basic Pay', p_effective_date);
988:
989: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 56',
990: p_pay_basis,'Minimum Basic Pay', p_effective_date);
991:
992: if ( max_basic_pay IS NOT NULL and min_basic_pay IS NOT NULL ) then
993: open c_fw_pay_plans;

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

1028: if p_pay_basis = 'PD' and
1029: (substr(p_agency_subelement,1,2) in ('CU','FD','FL','FY') or
1030: p_agency_subelement in ('TRAJ','TR35')) then
1031:
1032: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 18',
1033: p_pay_basis,
1034: 'Maximum Basic Pay',
1035: p_effective_date);
1036: if max_basic_pay is NOT NULL then

Line 3183: end GHR_CPDF_CHECK3;

3179: END IF;
3180:
3181: end chk_pay_rate_determinant;
3182:
3183: end GHR_CPDF_CHECK3;