DBA Data[Home] [Help]

APPS.HR_TEMPLATE_EXISTENCE dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 181: from pay_status_processing_rules_f spr

177: select spr.status_processing_rule_id,
178: spr.formula_id
179: into already_exists,
180: p_ff_id
181: from pay_status_processing_rules_f spr
182: where spr.element_type_id = p_ele_id
183: and spr.assignment_status_type_id IS NULL
184: and spr.business_group_id = p_bg_id
185: and p_val_date between spr.effective_start_date

Line 222: pay_status_processing_rules_f spr,

218: into already_exists,
219: p_ff_name,
220: p_ff_text
221: from pay_element_types_f pet,
222: pay_status_processing_rules_f spr,
223: ff_formulas_f ff
224: where upper(pet.element_name) = upper(p_ele_name)
225: and pet.business_group_id = p_bg_id
226: and p_eff_date between pet.effective_start_date