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 1048: from pay_formula_result_rules_f

1044: --
1045: cursor c_duplicate_rule
1046: is
1047: select '1'
1048: from pay_formula_result_rules_f
1049: where status_processing_rule_id = p_status_processing_rule_id
1050: and result_rule_type = 'M'
1051: and result_name = p_result_name
1052: and p_effective_date between effective_start_date

Line 1083: from pay_formula_result_rules_f

1079: --
1080: cursor c_duplicate_rule
1081: is
1082: select '1'
1083: from pay_formula_result_rules_f
1084: where status_processing_rule_id = p_status_processing_rule_id
1085: and result_rule_type in ('S','U')
1086: and result_name = p_result_name
1087: and element_type_id = p_element_type_id

Line 1118: from pay_formula_result_rules_f

1114: --
1115: cursor c_duplicate_rule
1116: is
1117: select '1'
1118: from pay_formula_result_rules_f
1119: where status_processing_rule_id = p_status_processing_rule_id
1120: and result_rule_type = p_result_rule_type
1121: and result_name = p_result_name
1122: and input_value_id = p_input_value_id