DBA Data[Home] [Help]

APPS.PAY_RETRO_UTILS_PKG dependencies on PAY_LEGISLATION_RULES

Line 144: , pay_legislation_rules lr

140: cursor csr_manual_flag(cp_pay_id in number) is
141: select lr.rule_mode
142: from pay_all_payrolls_f paa
143: , per_business_groups_perf pbg
144: , pay_legislation_rules lr
145: where paa.business_group_id = pbg.business_group_id
146: and lr.legislation_code = pbg.legislation_code
147: and lr.rule_type = 'RETRO_STATUS_USER_UPD'
148: and paa.payroll_id = cp_pay_id;