DBA Data[Home] [Help]

APPS.PAY_PGR_BUS dependencies on PER_BUSINESS_GROUPS

Line 565: l_bg_curr_code per_business_groups.currency_code%type; -- added for bug 6016428 (for backward compatibility)

561: l_format varchar2(255);
562: l_input varchar2(255);
563: l_proc VARCHAR2(72) := g_package||'chk_values_format';
564: l_bg_id pay_rates.business_group_id%type; -- added for bug 6016428 (for backward compatibility)
565: l_bg_curr_code per_business_groups.currency_code%type; -- added for bug 6016428 (for backward compatibility)
566:
567: --
568: CURSOR csr_get_rate_uom IS
569: SELECT pr.rate_uom

Line 925: from per_business_groups pbg

921: -- Declare cursor
922: --
923: cursor csr_sec_grp is
924: select pbg.security_group_id
925: from per_business_groups pbg
926: , pay_grade_rules_f pgr
927: where pgr.grade_rule_id = p_grade_rule_id
928: and pbg.business_group_id = pgr.business_group_id;
929: --

Line 989: from per_business_groups pbg

985: -- Declare cursor
986: --
987: cursor csr_leg_code is
988: select pbg.legislation_code
989: from per_business_groups pbg
990: , pay_grade_rules_f pgr
991: where pgr.grade_rule_id = p_grade_rule_id
992: and pbg.business_group_id = pgr.business_group_id;
993: --