APPS.PAY_FORMULA_RESULT_RULE_API dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 38: l_element_type_id pay_status_processing_rules_f.element_type_id%type;

34: l_effective_start_date date;
35: l_effective_end_date date;
36: l_formula_result_rule_id number;
37: l_object_version_number number;
38: l_element_type_id pay_status_processing_rules_f.element_type_id%type;
39: --
40: cursor c_spr_element is
41: select element_type_id
42: from pay_status_processing_rules_f spr

Line 42: from pay_status_processing_rules_f spr

38: l_element_type_id pay_status_processing_rules_f.element_type_id%type;
39: --
40: cursor c_spr_element is
41: select element_type_id
42: from pay_status_processing_rules_f spr
43: where spr.status_processing_rule_id = p_status_processing_rule_id
44: and p_effective_date between spr.effective_start_date
45: and spr.effective_end_date;
46: --

Line 216: l_element_type_id pay_status_processing_rules_f.element_type_id%type;

212: l_effective_date date;
213: l_effective_start_date date;
214: l_effective_end_date date;
215: l_object_version_number number;
216: l_element_type_id pay_status_processing_rules_f.element_type_id%type;
217: --
218: cursor c_spr_element is
219: select spr.element_type_id
220: from pay_formula_result_rules_f frr

Line 221: ,pay_status_processing_rules_f spr

217: --
218: cursor c_spr_element is
219: select spr.element_type_id
220: from pay_formula_result_rules_f frr
221: ,pay_status_processing_rules_f spr
222: where frr.formula_result_rule_id = p_formula_result_rule_id
223: and spr.status_processing_rule_id = frr.status_processing_rule_id
224: and p_effective_date between frr.effective_start_date
225: and frr.effective_end_date;