DBA Data[Home] [Help]

APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 458: FROM pay_status_processing_rules_f pspr

454: /* Gets the processing rule id for element */
455: CURSOR c_get_formula_results(c_element_type_id pay_element_types_f.element_type_id%type)
456: IS
457: SELECT pspr.status_processing_rule_id
458: FROM pay_status_processing_rules_f pspr
459: WHERE pspr.business_group_id = p_business_group_id
460: AND pspr.element_type_id = c_element_type_id;
461:
462: /* Checks whether formula result rule exist for the element */

Line 469: from pay_status_processing_rules_f pssp,

465: c_result_rule_type pay_formula_result_rules_f.result_rule_type%type,
466: c_input_value_id pay_formula_result_rules_f.input_value_id%type)
467: IS
468: select count(*)
469: from pay_status_processing_rules_f pssp,
470: pay_formula_result_rules_f pfrr
471: where pssp.element_type_id = c_element_type_id
472: and pfrr.status_processing_rule_id = pssp.status_processing_rule_id
473: AND pfrr.result_name = c_result_name