DBA Data[Home] [Help]

APPS.PAY_RETRO_UTILS_PKG dependencies on PER_BUSINESS_GROUPS_PERF

Line 143: , per_business_groups_perf pbg

139: -- level. In the future it will be possible to set this at payroll level
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'

Line 641: from per_business_groups_perf pbg

637: where paf.assignment_id = cp_asg_id;
638:
639: cursor csr_get_leg_code (cp_bg_id in number) IS
640: select pbg.legislation_code
641: from per_business_groups_perf pbg
642: where pbg.business_group_id = cp_bg_id;
643:
644: l_legrul_name varchar2(40) := 'RETRO_COMP_DFLT_OVERRIDE';
645: l_asg_id number;