APPS.PAY_FRR_BUS dependencies on PAY_FORMULA_RESULT_RULES_F

Line 35: , pay_formula_result_rules_f frr

31: cursor csr_sec_grp is
32: select pbg.security_group_id,
33: pbg.legislation_code
34: from per_business_groups_perf pbg
35: , pay_formula_result_rules_f frr
36: where frr.formula_result_rule_id = p_formula_result_rule_id
37: and pbg.business_group_id (+) = frr.business_group_id;
38: --
39: -- Declare local variables

Line 105: , pay_formula_result_rules_f frr

101: --
102: cursor csr_leg_code is
103: select pbg.legislation_code
104: from per_business_groups_perf pbg
105: , pay_formula_result_rules_f frr
106: where frr.formula_result_rule_id = p_formula_result_rule_id
107: and pbg.business_group_id (+) = frr.business_group_id;
108: --
109: -- Declare local variables

Line 1067: from pay_formula_result_rules_f

1063: --
1064: cursor c_duplicate_rule
1065: is
1066: select '1'
1067: from pay_formula_result_rules_f
1068: where status_processing_rule_id = p_status_processing_rule_id
1069: and result_rule_type = 'M'
1070: and result_name = p_result_name
1071: and p_effective_date between effective_start_date

Line 1102: from pay_formula_result_rules_f

1098: --
1099: cursor c_duplicate_rule
1100: is
1101: select '1'
1102: from pay_formula_result_rules_f
1103: where status_processing_rule_id = p_status_processing_rule_id
1104: and result_rule_type in ('S','U')
1105: and result_name = p_result_name
1106: and element_type_id = p_element_type_id

Line 1137: from pay_formula_result_rules_f

1133: --
1134: cursor c_duplicate_rule
1135: is
1136: select '1'
1137: from pay_formula_result_rules_f
1138: where status_processing_rule_id = p_status_processing_rule_id
1139: and result_rule_type = p_result_rule_type
1140: and result_name = p_result_name
1141: and input_value_id = p_input_value_id