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.

APPS.PQP_NL_ABP_FUNCTIONS dependencies on PQP_PENSION_TYPES_F

Line 475: FROM pqp_pension_types_f

471: SELECT pension_sub_category,
472: threshold_conversion_rule,
473: contribution_conversion_rule,
474: pension_basis_calc_method
475: FROM pqp_pension_types_f
476: WHERE pension_type_id = to_number(c_pension_type_id);
477:
478: --
479: --Cursor to find the start and end dates for a particular pension type

Line 483: FROM pqp_pension_types_f

479: --Cursor to find the start and end dates for a particular pension type
480: --
481: CURSOR cur_get_st_end_dates(c_pension_type_id in varchar2) IS
482: SELECT effective_start_date,effective_end_date
483: FROM pqp_pension_types_f
484: WHERE pension_type_id = to_number(c_pension_type_id);
485:
486: --cursor to fetch the effective date the user has datetracked to
487: CURSOR c_get_eff_date IS

Line 535: l_pen_sub_cat1 pqp_pension_types_f.pension_sub_category%TYPE;

531:
532: l_min_start_date DATE;
533: l_max_end_date DATE;
534: l_counter NUMBER := 0;
535: l_pen_sub_cat1 pqp_pension_types_f.pension_sub_category%TYPE;
536: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;
537: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
538: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
539: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;

Line 536: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;

532: l_min_start_date DATE;
533: l_max_end_date DATE;
534: l_counter NUMBER := 0;
535: l_pen_sub_cat1 pqp_pension_types_f.pension_sub_category%TYPE;
536: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;
537: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
538: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
539: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;
540: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;

Line 537: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;

533: l_max_end_date DATE;
534: l_counter NUMBER := 0;
535: l_pen_sub_cat1 pqp_pension_types_f.pension_sub_category%TYPE;
536: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;
537: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
538: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
539: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;
540: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;
541: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;

Line 538: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;

534: l_counter NUMBER := 0;
535: l_pen_sub_cat1 pqp_pension_types_f.pension_sub_category%TYPE;
536: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;
537: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
538: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
539: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;
540: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;
541: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;
542: l_basis_method2 pqp_pension_types_f.pension_basis_calc_method%TYPE;

Line 539: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;

535: l_pen_sub_cat1 pqp_pension_types_f.pension_sub_category%TYPE;
536: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;
537: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
538: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
539: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;
540: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;
541: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;
542: l_basis_method2 pqp_pension_types_f.pension_basis_calc_method%TYPE;
543: l_min_st_dt DATE;

Line 540: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;

536: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;
537: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
538: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
539: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;
540: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;
541: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;
542: l_basis_method2 pqp_pension_types_f.pension_basis_calc_method%TYPE;
543: l_min_st_dt DATE;
544: l_max_end_dt DATE;

Line 541: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;

537: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
538: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
539: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;
540: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;
541: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;
542: l_basis_method2 pqp_pension_types_f.pension_basis_calc_method%TYPE;
543: l_min_st_dt DATE;
544: l_max_end_dt DATE;
545: l_min_schm_st DATE;

Line 542: l_basis_method2 pqp_pension_types_f.pension_basis_calc_method%TYPE;

538: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
539: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;
540: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;
541: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;
542: l_basis_method2 pqp_pension_types_f.pension_basis_calc_method%TYPE;
543: l_min_st_dt DATE;
544: l_max_end_dt DATE;
545: l_min_schm_st DATE;
546: l_max_schm_end DATE;

Line 1067: FROM pqp_pension_types_f

1063:
1064: --Cursor to find the start and end dates for a particular pension type
1065: CURSOR cur_get_st_end_dates(c_pension_type_id in varchar2) IS
1066: SELECT effective_start_date,effective_end_date
1067: FROM pqp_pension_types_f
1068: WHERE pension_type_id = to_number(c_pension_type_id);
1069:
1070: --Cursor to find the pension sub category for the ABP Pension Type
1071: CURSOR cur_get_pen_sub_cat(c_pension_type_id in varchar2) IS

Line 1076: FROM pqp_pension_types_f

1072: SELECT pension_sub_category
1073: ,threshold_conversion_rule
1074: ,contribution_conversion_rule
1075: ,pension_basis_calc_method
1076: FROM pqp_pension_types_f
1077: WHERE pension_type_id = to_number(c_pension_type_id);
1078:
1079: --Cursor to find all rows which have dates overlapping the current record dates
1080: CURSOR cur_get_overlap_rows IS

Line 1148: l_pen_sub_cat1 pqp_pension_types_f.pension_sub_category%TYPE;

1144: l_eff_date DATE;
1145: l_min_start_date DATE := NULL;
1146: l_max_end_date DATE := NULL;
1147: l_counter NUMBER := 0;
1148: l_pen_sub_cat1 pqp_pension_types_f.pension_sub_category%TYPE;
1149: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;
1150: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1151: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1152: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;

Line 1149: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;

1145: l_min_start_date DATE := NULL;
1146: l_max_end_date DATE := NULL;
1147: l_counter NUMBER := 0;
1148: l_pen_sub_cat1 pqp_pension_types_f.pension_sub_category%TYPE;
1149: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;
1150: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1151: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1152: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;
1153: l_basis_method2 pqp_pension_types_f.pension_basis_calc_method%TYPE;

Line 1150: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;

1146: l_max_end_date DATE := NULL;
1147: l_counter NUMBER := 0;
1148: l_pen_sub_cat1 pqp_pension_types_f.pension_sub_category%TYPE;
1149: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;
1150: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1151: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1152: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;
1153: l_basis_method2 pqp_pension_types_f.pension_basis_calc_method%TYPE;
1154: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;

Line 1151: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;

1147: l_counter NUMBER := 0;
1148: l_pen_sub_cat1 pqp_pension_types_f.pension_sub_category%TYPE;
1149: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;
1150: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1151: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1152: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;
1153: l_basis_method2 pqp_pension_types_f.pension_basis_calc_method%TYPE;
1154: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;
1155: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;

Line 1152: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;

1148: l_pen_sub_cat1 pqp_pension_types_f.pension_sub_category%TYPE;
1149: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;
1150: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1151: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1152: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;
1153: l_basis_method2 pqp_pension_types_f.pension_basis_calc_method%TYPE;
1154: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;
1155: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;
1156: l_min_st_dt DATE;

Line 1153: l_basis_method2 pqp_pension_types_f.pension_basis_calc_method%TYPE;

1149: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;
1150: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1151: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1152: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;
1153: l_basis_method2 pqp_pension_types_f.pension_basis_calc_method%TYPE;
1154: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;
1155: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;
1156: l_min_st_dt DATE;
1157: l_max_end_dt DATE;

Line 1154: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;

1150: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1151: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1152: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;
1153: l_basis_method2 pqp_pension_types_f.pension_basis_calc_method%TYPE;
1154: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;
1155: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;
1156: l_min_st_dt DATE;
1157: l_max_end_dt DATE;
1158: l_min_schm_st DATE;

Line 1155: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;

1151: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1152: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;
1153: l_basis_method2 pqp_pension_types_f.pension_basis_calc_method%TYPE;
1154: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;
1155: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;
1156: l_min_st_dt DATE;
1157: l_max_end_dt DATE;
1158: l_min_schm_st DATE;
1159: l_max_schm_end DATE;

Line 1849: FROM pqp_pension_types_f

1845:
1846: --Cursor to find the start and end dates for a particular pension type
1847: CURSOR cur_get_st_end_dates(c_pension_type_id in varchar2) IS
1848: SELECT effective_start_date,effective_end_date
1849: FROM pqp_pension_types_f
1850: WHERE pension_type_id = to_number(c_pension_type_id);
1851:
1852: --cursor to find all the EIT rows which have a salary override
1853: --and fall in the current year

Line 1874: FROM pqp_pension_types_f

1870: SELECT pension_sub_category
1871: ,threshold_conversion_rule
1872: ,contribution_conversion_rule
1873: ,pension_basis_calc_method
1874: FROM pqp_pension_types_f
1875: WHERE pension_type_id = to_number(c_pension_type_id);
1876:
1877: --Cursor to find all rows which have dates overlapping the current record dates
1878: CURSOR cur_get_overlap_rows IS

Line 1944: l_pen_sub_cat1 pqp_pension_types_f.pension_sub_category%TYPE;

1940:
1941: l_min_start_date DATE;
1942: l_max_end_date DATE;
1943: l_counter NUMBER := 0;
1944: l_pen_sub_cat1 pqp_pension_types_f.pension_sub_category%TYPE;
1945: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;
1946: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1947: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1948: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;

Line 1945: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;

1941: l_min_start_date DATE;
1942: l_max_end_date DATE;
1943: l_counter NUMBER := 0;
1944: l_pen_sub_cat1 pqp_pension_types_f.pension_sub_category%TYPE;
1945: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;
1946: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1947: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1948: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;
1949: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;

Line 1946: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;

1942: l_max_end_date DATE;
1943: l_counter NUMBER := 0;
1944: l_pen_sub_cat1 pqp_pension_types_f.pension_sub_category%TYPE;
1945: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;
1946: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1947: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1948: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;
1949: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;
1950: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;

Line 1947: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;

1943: l_counter NUMBER := 0;
1944: l_pen_sub_cat1 pqp_pension_types_f.pension_sub_category%TYPE;
1945: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;
1946: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1947: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1948: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;
1949: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;
1950: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;
1951: l_basis_method2 pqp_pension_types_f.pension_basis_calc_method%TYPE;

Line 1948: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;

1944: l_pen_sub_cat1 pqp_pension_types_f.pension_sub_category%TYPE;
1945: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;
1946: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1947: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1948: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;
1949: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;
1950: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;
1951: l_basis_method2 pqp_pension_types_f.pension_basis_calc_method%TYPE;
1952: l_min_st_dt DATE;

Line 1949: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;

1945: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;
1946: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1947: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1948: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;
1949: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;
1950: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;
1951: l_basis_method2 pqp_pension_types_f.pension_basis_calc_method%TYPE;
1952: l_min_st_dt DATE;
1953: l_max_end_dt DATE;

Line 1950: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;

1946: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1947: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1948: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;
1949: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;
1950: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;
1951: l_basis_method2 pqp_pension_types_f.pension_basis_calc_method%TYPE;
1952: l_min_st_dt DATE;
1953: l_max_end_dt DATE;
1954: l_hire_date DATE;

Line 1951: l_basis_method2 pqp_pension_types_f.pension_basis_calc_method%TYPE;

1947: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
1948: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;
1949: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;
1950: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;
1951: l_basis_method2 pqp_pension_types_f.pension_basis_calc_method%TYPE;
1952: l_min_st_dt DATE;
1953: l_max_end_dt DATE;
1954: l_hire_date DATE;
1955: l_min_schm_st DATE;

Line 2823: FROM pqp_pension_types_f

2819:
2820: --Cursor to find the start and end dates for a particular pension type
2821: CURSOR cur_get_st_end_dates(c_pension_type_id in varchar2) IS
2822: SELECT effective_start_date,effective_end_date
2823: FROM pqp_pension_types_f
2824: WHERE pension_type_id = to_number(c_pension_type_id);
2825:
2826: --Cursor to find the pension sub category for the ABP Pension Type
2827: CURSOR cur_get_pen_sub_cat(c_pension_type_id in varchar2) IS

Line 2832: FROM pqp_pension_types_f

2828: SELECT pension_sub_category
2829: ,threshold_conversion_rule
2830: ,contribution_conversion_rule
2831: ,pension_basis_calc_method
2832: FROM pqp_pension_types_f
2833: WHERE pension_type_id = to_number(c_pension_type_id);
2834:
2835: --Cursor to find all rows which have dates overlapping the current record dates
2836: CURSOR cur_get_overlap_rows IS

Line 2925: l_pen_sub_cat1 pqp_pension_types_f.pension_sub_category%TYPE;

2921:
2922: l_min_start_date DATE := NULL;
2923: l_max_end_date DATE := NULL;
2924: l_counter NUMBER := 0;
2925: l_pen_sub_cat1 pqp_pension_types_f.pension_sub_category%TYPE;
2926: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;
2927: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
2928: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
2929: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;

Line 2926: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;

2922: l_min_start_date DATE := NULL;
2923: l_max_end_date DATE := NULL;
2924: l_counter NUMBER := 0;
2925: l_pen_sub_cat1 pqp_pension_types_f.pension_sub_category%TYPE;
2926: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;
2927: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
2928: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
2929: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;
2930: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;

Line 2927: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;

2923: l_max_end_date DATE := NULL;
2924: l_counter NUMBER := 0;
2925: l_pen_sub_cat1 pqp_pension_types_f.pension_sub_category%TYPE;
2926: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;
2927: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
2928: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
2929: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;
2930: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;
2931: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;

Line 2928: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;

2924: l_counter NUMBER := 0;
2925: l_pen_sub_cat1 pqp_pension_types_f.pension_sub_category%TYPE;
2926: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;
2927: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
2928: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
2929: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;
2930: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;
2931: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;
2932: l_basis_method2 pqp_pension_types_f.pension_basis_calc_method%TYPE;

Line 2929: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;

2925: l_pen_sub_cat1 pqp_pension_types_f.pension_sub_category%TYPE;
2926: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;
2927: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
2928: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
2929: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;
2930: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;
2931: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;
2932: l_basis_method2 pqp_pension_types_f.pension_basis_calc_method%TYPE;
2933: l_min_st_dt DATE;

Line 2930: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;

2926: l_pen_sub_cat2 pqp_pension_types_f.pension_sub_category%TYPE;
2927: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
2928: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
2929: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;
2930: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;
2931: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;
2932: l_basis_method2 pqp_pension_types_f.pension_basis_calc_method%TYPE;
2933: l_min_st_dt DATE;
2934: l_max_end_dt DATE;

Line 2931: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;

2927: l_thresh_conv_rule1 pqp_pension_types_f.threshold_conversion_rule%TYPE;
2928: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
2929: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;
2930: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;
2931: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;
2932: l_basis_method2 pqp_pension_types_f.pension_basis_calc_method%TYPE;
2933: l_min_st_dt DATE;
2934: l_max_end_dt DATE;
2935: l_hire_date DATE;

Line 2932: l_basis_method2 pqp_pension_types_f.pension_basis_calc_method%TYPE;

2928: l_thresh_conv_rule2 pqp_pension_types_f.threshold_conversion_rule%TYPE;
2929: l_contrib_conv_rule1 pqp_pension_types_f.contribution_conversion_rule%TYPE;
2930: l_contrib_conv_rule2 pqp_pension_types_f.contribution_conversion_rule%TYPE;
2931: l_basis_method1 pqp_pension_types_f.pension_basis_calc_method%TYPE;
2932: l_basis_method2 pqp_pension_types_f.pension_basis_calc_method%TYPE;
2933: l_min_st_dt DATE;
2934: l_max_end_dt DATE;
2935: l_hire_date DATE;
2936: l_min_schm_st DATE;

Line 3838: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE

3834: --
3835: FUNCTION get_vop
3836: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
3837: ,p_date_earned IN DATE
3838: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
3839: ,p_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE
3840: ,p_vop OUT NOCOPY VARCHAR2
3841: ,p_error_message OUT NOCOPY VARCHAR2
3842: ) RETURN NUMBER IS

Line 3839: ,p_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE

3835: FUNCTION get_vop
3836: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
3837: ,p_date_earned IN DATE
3838: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
3839: ,p_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE
3840: ,p_vop OUT NOCOPY VARCHAR2
3841: ,p_error_message OUT NOCOPY VARCHAR2
3842: ) RETURN NUMBER IS
3843:

Line 3924: pqp_pension_types_f pty

3920: SELECT fnd_number.canonical_to_number(nvl(aei_information23,'1')) VOP
3921: ,TRUNC(fnd_date.canonical_to_date(aei_information1)) St_Dt
3922: ,TRUNC(NVL(fnd_date.canonical_to_date(aei_information2),c_ed_dt)) Ed_Dt
3923: FROM per_assignment_extra_info aei,
3924: pqp_pension_types_f pty
3925: WHERE assignment_id = p_assignment_id
3926: AND aei_information3 = p_pension_type_id
3927: AND pty.pension_type_id = fnd_number.canonical_to_number(aei.aei_information3)
3928: AND pension_sub_category IN ('PPP' ,'OPNP' ,'OPNP_65'

Line 3945: pqp_pension_types_f pty

3941: SELECT fnd_number.canonical_to_number(nvl(aei_information23,'1')) VOP
3942: ,TRUNC(fnd_date.canonical_to_date(aei_information1)) St_Dt
3943: ,TRUNC(NVL(fnd_date.canonical_to_date(aei_information2),c_ed_dt)) Ed_Dt
3944: FROM per_assignment_extra_info aei,
3945: pqp_pension_types_f pty
3946: WHERE assignment_id = p_assignment_id
3947: AND aei_information3 = p_pension_type_id
3948: AND pty.pension_type_id = fnd_number.canonical_to_number(aei.aei_information3)
3949: AND pension_sub_category in ('PPP' ,'OPNP' ,'OPNP_65'

Line 3967: pqp_pension_types_f pty

3963: SELECT fnd_number.canonical_to_number(nvl(aei_information23,'1')) VOP
3964: ,TRUNC(fnd_date.canonical_to_date(aei_information1)) St_Dt
3965: ,TRUNC(NVL(fnd_date.canonical_to_date(aei_information2),c_ed_dt)) Ed_Dt
3966: FROM per_assignment_extra_info aei,
3967: pqp_pension_types_f pty
3968: WHERE assignment_id = p_assignment_id
3969: AND aei_information3 = p_pension_type_id
3970: AND pty.pension_type_id = fnd_number.canonical_to_number(aei.aei_information3)
3971: AND pension_sub_category in ('PPP' ,'OPNP' ,'OPNP_65'

Line 4123: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE

4119: --
4120: FUNCTION get_assignment_attribute
4121: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4122: ,p_date_earned in date
4123: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
4124: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE
4125: ,p_attrib_name in varchar2
4126: ,p_attrib_value out NOCOPY varchar2
4127: ,p_error_message out NOCOPY varchar2

Line 4124: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE

4120: FUNCTION get_assignment_attribute
4121: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4122: ,p_date_earned in date
4123: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
4124: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE
4125: ,p_attrib_name in varchar2
4126: ,p_attrib_value out NOCOPY varchar2
4127: ,p_error_message out NOCOPY varchar2
4128: )

Line 4142: l_pen_type_name pqp_pension_types_f.pension_type_name%type;

4138: g_asg_extra_info_rec1 t_asg_extra_info;
4139:
4140: l_ret_value number := 0; --return
4141: l_is_ptype_valid number;
4142: l_pen_type_name pqp_pension_types_f.pension_type_name%type;
4143: l_asg_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
4144: l_asg_extra_info_id1 per_assignment_extra_info.assignment_extra_info_id%type;
4145: l_override_found number := 0;
4146: l_vop_ret_val NUMBER;

Line 4151: from pqp_pension_types_f pty

4147:
4148: --Cursor to check if the pension type is valid on the date earned
4149: Cursor c_is_ptype_valid Is
4150: Select 1
4151: from pqp_pension_types_f pty
4152: where pty.pension_type_id = p_pension_type_id
4153: and pty.business_group_id = p_business_group_id
4154: and p_date_earned between pty.effective_start_date and pty.effective_end_date;
4155:

Line 4159: from pqp_pension_types_f

4155:
4156: --Cursor to find the pension type name from the id
4157: Cursor c_find_pen_type_name Is
4158: Select pension_type_name
4159: from pqp_pension_types_f
4160: where pension_type_id = p_pension_type_id
4161: and business_group_id = p_business_group_id;
4162:
4163: --Cursor to find if the pension type has a valid information row at the --assignment level

Line 4168: pqp_pension_types_f pty

4164: -- if so qry up the asg extra info id
4165: CURSOR c_get_asg_extra_info_id IS
4166: Select paei.assignment_extra_info_id
4167: from per_assignment_extra_info paei,
4168: pqp_pension_types_f pty
4169: where paei.information_type = 'NL_ABP_PI'
4170: and paei.aei_information_category = 'NL_ABP_PI'
4171: and paei.aei_information3 = to_char(p_pension_type_id)
4172: and paei.assignment_id = p_assignment_id

Line 4409: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE

4405:
4406: FUNCTION get_contribution_percent
4407: ( p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4408: ,p_date_earned in date
4409: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
4410: ,p_pension_sub_cat in pqp_pension_types_f.pension_sub_category%TYPE
4411: ,p_udt_table_name in VARCHAR2
4412: ,p_column_value out NOCOPY number
4413: )

Line 4410: ,p_pension_sub_cat in pqp_pension_types_f.pension_sub_category%TYPE

4406: FUNCTION get_contribution_percent
4407: ( p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4408: ,p_date_earned in date
4409: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
4410: ,p_pension_sub_cat in pqp_pension_types_f.pension_sub_category%TYPE
4411: ,p_udt_table_name in VARCHAR2
4412: ,p_column_value out NOCOPY number
4413: )
4414: RETURN NUMBER IS

Line 4522: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE

4518: --
4519: FUNCTION chk_pt_eligibility
4520: ( p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
4521: ,p_date_earned IN DATE
4522: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
4523: ,p_pt_id IN NUMBER
4524: ,p_hr_org_org_id IN NUMBER
4525: ,p_le_org_id IN NUMBER)
4526: RETURN NUMBER IS

Line 4633: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE

4629: --
4630: FUNCTION get_abp_org_contrib_percent
4631: ( p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
4632: ,p_date_earned IN DATE
4633: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
4634: ,p_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE
4635: ,p_ee_contrib OUT NOCOPY NUMBER
4636: ,p_er_contrib OUT NOCOPY NUMBER
4637: ,p_app_to_all_ee IN VARCHAR2)

Line 4634: ,p_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE

4630: FUNCTION get_abp_org_contrib_percent
4631: ( p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
4632: ,p_date_earned IN DATE
4633: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
4634: ,p_pension_type_id IN pqp_pension_types_f.pension_type_id%TYPE
4635: ,p_ee_contrib OUT NOCOPY NUMBER
4636: ,p_er_contrib OUT NOCOPY NUMBER
4637: ,p_app_to_all_ee IN VARCHAR2)
4638: RETURN NUMBER IS

Line 4683: FROM pqp_pension_types_f

4679: --
4680: CURSOR c_pt_val IS
4681: SELECT fnd_number.canonical_to_number(nvl(ee_contribution_percent,'0'))
4682: ,fnd_number.canonical_to_number(nvl(er_contribution_percent,'0'))
4683: FROM pqp_pension_types_f
4684: WHERE pension_type_id = p_pension_type_id
4685: AND p_date_earned BETWEEN effective_start_date
4686: AND effective_end_date;
4687:

Line 4806: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE

4802: -- ------------------------------------------------------------------------
4803: --
4804: FUNCTION chk_abp_scheme_created
4805: (p_date_earned IN DATE
4806: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
4807: ,p_pension_sub_cat IN pqp_pension_types_f.pension_sub_category%TYPE
4808: ,p_pension_type_id OUT NOCOPY NUMBER)
4809:
4810: RETURN NUMBER IS

Line 4807: ,p_pension_sub_cat IN pqp_pension_types_f.pension_sub_category%TYPE

4803: --
4804: FUNCTION chk_abp_scheme_created
4805: (p_date_earned IN DATE
4806: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
4807: ,p_pension_sub_cat IN pqp_pension_types_f.pension_sub_category%TYPE
4808: ,p_pension_type_id OUT NOCOPY NUMBER)
4809:
4810: RETURN NUMBER IS
4811: --

Line 4890: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE

4886: --
4887: FUNCTION get_abp_contribution
4888: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
4889: ,p_date_earned IN DATE
4890: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
4891: ,p_payroll_action_id IN NUMBER
4892: ,p_pension_sub_cat IN pqp_pension_types_f.pension_sub_category%TYPE
4893: ,p_conversion_rule IN pqp_pension_types_f.threshold_conversion_rule%TYPE
4894: ,p_basis_method IN pqp_pension_types_f.pension_basis_calc_method%TYPE

Line 4892: ,p_pension_sub_cat IN pqp_pension_types_f.pension_sub_category%TYPE

4888: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
4889: ,p_date_earned IN DATE
4890: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
4891: ,p_payroll_action_id IN NUMBER
4892: ,p_pension_sub_cat IN pqp_pension_types_f.pension_sub_category%TYPE
4893: ,p_conversion_rule IN pqp_pension_types_f.threshold_conversion_rule%TYPE
4894: ,p_basis_method IN pqp_pension_types_f.pension_basis_calc_method%TYPE
4895: ,p_ee_contrib_type OUT NOCOPY NUMBER
4896: ,p_ee_contrib_value OUT NOCOPY NUMBER

Line 4893: ,p_conversion_rule IN pqp_pension_types_f.threshold_conversion_rule%TYPE

4889: ,p_date_earned IN DATE
4890: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
4891: ,p_payroll_action_id IN NUMBER
4892: ,p_pension_sub_cat IN pqp_pension_types_f.pension_sub_category%TYPE
4893: ,p_conversion_rule IN pqp_pension_types_f.threshold_conversion_rule%TYPE
4894: ,p_basis_method IN pqp_pension_types_f.pension_basis_calc_method%TYPE
4895: ,p_ee_contrib_type OUT NOCOPY NUMBER
4896: ,p_ee_contrib_value OUT NOCOPY NUMBER
4897: ,p_er_contrib_type OUT NOCOPY NUMBER

Line 4894: ,p_basis_method IN pqp_pension_types_f.pension_basis_calc_method%TYPE

4890: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
4891: ,p_payroll_action_id IN NUMBER
4892: ,p_pension_sub_cat IN pqp_pension_types_f.pension_sub_category%TYPE
4893: ,p_conversion_rule IN pqp_pension_types_f.threshold_conversion_rule%TYPE
4894: ,p_basis_method IN pqp_pension_types_f.pension_basis_calc_method%TYPE
4895: ,p_ee_contrib_type OUT NOCOPY NUMBER
4896: ,p_ee_contrib_value OUT NOCOPY NUMBER
4897: ,p_er_contrib_type OUT NOCOPY NUMBER
4898: ,p_er_contrib_value OUT NOCOPY NUMBER

Line 4980: FROM pqp_pension_types_f pty

4976: SELECT NVL(pty.ee_age_contribution,'N')
4977: ,NVL(pty.er_age_contribution,'N')
4978: ,ee_contribution_percent
4979: ,er_contribution_percent
4980: FROM pqp_pension_types_f pty
4981: WHERE c_date_earned BETWEEN pty.effective_start_date
4982: AND pty.effective_end_date
4983: AND pension_type_id = c_pty_id;
4984:

Line 5522: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE

5518: --
5519: FUNCTION get_participation_date
5520: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5521: ,p_date_earned in date
5522: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
5523: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE
5524: ,p_start_date out NOCOPY date
5525: )
5526: RETURN number IS

Line 5523: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE

5519: FUNCTION get_participation_date
5520: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5521: ,p_date_earned in date
5522: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
5523: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE
5524: ,p_start_date out NOCOPY date
5525: )
5526: RETURN number IS
5527:

Line 5731: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE

5727: --
5728: PROCEDURE get_participation_org
5729: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5730: ,p_date_earned in date
5731: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE
5732: ,p_asg_or_org out NOCOPY number
5733: ,p_org_id out NOCOPY number
5734: )
5735: IS

Line 6011: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE

6007: --
6008: FUNCTION get_absence_adjustment
6009: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
6010: ,p_date_earned in date
6011: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
6012: ,p_dedn_amt in number
6013: ,p_adjust_amt out NOCOPY number
6014: ,p_error_message out NOCOPY varchar2
6015: )

Line 6213: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE

6209: --
6210: FUNCTION get_proration_factor
6211: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
6212: ,p_date_earned in date
6213: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
6214: ,p_proration_factor out NOCOPY number
6215: ,p_error_message out NOCOPY varchar2
6216: )
6217: RETURN number IS

Line 6325: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE

6321: -- ------------------------------------------------------------------------
6322: --
6323: FUNCTION get_abp_calc_eff_dt
6324: (p_date_earned IN DATE
6325: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
6326: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
6327: ,p_effective_date OUT NOCOPY DATE
6328: )
6329:

Line 6405: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE

6401: -- ------------------------------------------------------------------------
6402: --
6403: FUNCTION get_proration_flag
6404: (p_date_earned IN DATE
6405: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
6406: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
6407: ,p_assignment_action_id IN per_all_assignments_f.assignment_id%TYPE
6408: ,p_element_type_id IN pay_element_types_f.element_type_id%TYPE
6409: ,p_start_date IN DATE

Line 6448: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE

6444: -- ------------------------------------------------------------------------
6445: --
6446: FUNCTION get_eoy_bonus_percentage
6447: (p_date_earned IN date
6448: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
6449: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
6450: ,p_eoy_bonus_percentage OUT NOCOPY number
6451: )
6452: RETURN NUMBER IS

Line 7117: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE

7113: -- |-------------------------< abp_proration >-------------------------------|
7114: -- ----------------------------------------------------------------------------
7115: --
7116: function abp_proration
7117: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
7118: ,p_date_earned in date
7119: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
7120: ,p_amount in number
7121: ,p_payroll_period in varchar2