DBA Data[Home] [Help]

APPS.PAY_FORMULA_RESULTS dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 77: INSERT INTO pay_status_processing_rules_f

73: SELECT pay_status_processing_rules_s.nextval
74: INTO v_stat_proc_rule_id
75: FROM sys.dual;
76: --
77: INSERT INTO pay_status_processing_rules_f
78: (STATUS_PROCESSING_RULE_ID,
79: EFFECTIVE_START_DATE,
80: EFFECTIVE_END_DATE,
81: BUSINESS_GROUP_ID,

Line 160: pay_status_processing_rules_f spr

156: if (p_result_rule_type = 'D' and p_input_value_id is null) then
157: SELECT inp.input_value_id
158: INTO v_input_value_id
159: FROM pay_input_values_f inp,
160: pay_status_processing_rules_f spr
161: WHERE spr.status_processing_rule_id = p_status_processing_rule_id
162: AND inp.element_type_id = spr.element_type_id
163: AND inp.name = 'Pay Value';
164: else