APPS.PAY_GB_ENROLL_PENSION dependencies on PAY_FORMULA_RESULT_RULES_F

Line 895: FROM PAY_FORMULA_RESULT_RULES_F FRR

891: AND g_payroll_end_date BETWEEN pivf.EFFECTIVE_START_DATE AND pivf.EFFECTIVE_END_DATE ;
892: CURSOR GET_PAY_VAL_RSLT_NAME(P_STAT_PROC_RULE_ID NUMBER, P_PAY_VALUE_ID NUMBER)
893: IS
894: SELECT RESULT_NAME
895: FROM PAY_FORMULA_RESULT_RULES_F FRR
896: WHERE STATUS_PROCESSING_RULE_ID = P_STAT_PROC_RULE_ID
897: AND RESULT_RULE_TYPE ='D'
898: AND INPUT_VALUE_ID = P_PAY_VALUE_ID
899: AND g_payroll_end_date BETWEEN FRR.EFFECTIVE_START_DATE AND FRR.EFFECTIVE_END_DATE ;

Line 904: l_result_rule_name PAY_FORMULA_RESULT_RULES_F.RESULT_NAME%TYPE;

900: C_ACTION_IDS_ROW C_ACTION_IDS%ROWTYPE;
901: L_INPUTS FF_EXEC.INPUTS_T;
902: P_INPUTS FF_EXEC.INPUTS_T;
903: L_OUTPUTS FF_EXEC.OUTPUTS_T;
904: l_result_rule_name PAY_FORMULA_RESULT_RULES_F.RESULT_NAME%TYPE;
905: Iteration NUMBER;
906: l_pay_value_ivid NUMBER;
907: L_EARNINGS_VALUE NUMBER := 0;
908: l_element_type_id NUMBER ; -- Bug 14064422

Line 1087: FROM pay_formula_result_rules_f frr,

1083: --Fetch Result Name from the Formula Results
1084: CURSOR C_RESULT_RULE_NAME (P_STATUS_PROCESSING_RULE_ID NUMBER,P_EFFECTIVE_DATE DATE)
1085: IS
1086: SELECT result_name
1087: FROM pay_formula_result_rules_f frr,
1088: pay_input_values_f pivf
1089: WHERE RESULT_RULE_TYPE = 'I'
1090: AND STATUS_PROCESSING_RULE_ID= P_STATUS_PROCESSING_RULE_ID
1091: AND P_EFFECTIVE_DATE BETWEEN frr.EFFECTIVE_START_DATE AND frr.EFFECTIVE_END_DATE

Line 1105: L_RESULT_NAME pay_formula_result_rules_f.result_name%type :=NULL;

1101: AND frr.INPUT_VALUE_ID = pivf.INPUT_VALUE_ID
1102: AND pivf.name ='Pay Value';
1103: L_FORMULA_ID NUMBER;
1104: L_STATUS_PROCESSING_RULE_ID NUMBER;
1105: L_RESULT_NAME pay_formula_result_rules_f.result_name%type :=NULL;
1106: L_EARNINGS NUMBER :=0;
1107: BEGIN
1108: HR_UTILITY.trace(' Information CALCULATE_EARNINGS_INFO');
1109: HR_UTILITY.trace(' P_ASSIGNMENT_ID:'||P_ASSIGNMENT_ID);

Line 1212: L_RESULT_RULE_NAME PAY_FORMULA_RESULT_RULES_F.RESULT_NAME%TYPE;

1208: P_INPUTS FF_EXEC.INPUTS_T;
1209: L_OUTPUTS FF_EXEC.OUTPUTS_T;
1210: L_ASSIGNMENT_ACTION_ID NUMBER :=NULL;
1211: P_PAY_VALUE_IVID NUMBER;
1212: L_RESULT_RULE_NAME PAY_FORMULA_RESULT_RULES_F.RESULT_NAME%TYPE;
1213: Iteration NUMBER;
1214: L_TIME_PERIOD_ID NUMBER :=0;
1215: BEGIN
1216: L_BALANCE_FLAG :='N';

Line 1350: L_RESULT_RULE_NAME PAY_FORMULA_RESULT_RULES_F.RESULT_NAME%TYPE;

1346: L_OUTPUTS FF_EXEC.OUTPUTS_T;
1347: L_ASSIGNMENT_ACTION_ID NUMBER :=NULL;
1348: L_BALANCE_FLAG VARCHAR(2) := 'N';
1349: P_PAY_VALUE_IVID NUMBER;
1350: L_RESULT_RULE_NAME PAY_FORMULA_RESULT_RULES_F.RESULT_NAME%TYPE;
1351: Iteration NUMBER;
1352: L_TIME_PERIOD_ID NUMBER :=0;
1353: BEGIN
1354: hr_utility.trace('Inside CALCULATE_EARNINGS');

Line 3635: L_RESULT_RULE_NAME PAY_FORMULA_RESULT_RULES_F.RESULT_NAME%TYPE;

3631: L_OUTPUTS FF_EXEC.OUTPUTS_T;
3632: L_ASSIGNMENT_ACTION_ID NUMBER :=NULL;
3633: L_BALANCE_FLAG VARCHAR(2) := 'N';
3634: P_PAY_VALUE_IVID NUMBER;
3635: L_RESULT_RULE_NAME PAY_FORMULA_RESULT_RULES_F.RESULT_NAME%TYPE;
3636: Iteration NUMBER;
3637: L_TIME_PERIOD_ID NUMBER :=0;
3638: L_PRP_START_DATE date;
3639: L_PRP_END_DATE date;