DBA Data[Home] [Help]

APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 431: FROM pay_status_processing_rules_f pspr

427: /* Gets the processing rule id for element */
428: CURSOR c_get_formula_results(c_element_type_id pay_element_types_f.element_type_id%type)
429: IS
430: SELECT pspr.status_processing_rule_id
431: FROM pay_status_processing_rules_f pspr
432: WHERE pspr.business_group_id = p_business_group_id
433: AND pspr.element_type_id = c_element_type_id;
434:
435: /* Checks whether formula result rule exist for the element */

Line 442: from pay_status_processing_rules_f pssp,

438: c_result_rule_type pay_formula_result_rules_f.result_rule_type%type,
439: c_input_value_id pay_formula_result_rules_f.input_value_id%type)
440: IS
441: select count(*)
442: from pay_status_processing_rules_f pssp,
443: pay_formula_result_rules_f pfrr
444: where pssp.element_type_id = c_element_type_id
445: and pfrr.status_processing_rule_id = pssp.status_processing_rule_id
446: AND pfrr.result_name = c_result_name