APPS.PAY_GRR_BUS dependencies on PER_BUSINESS_GROUPS

Line 472: l_currency_code per_business_groups.currency_code%TYPE;

468: l_maximum pay_grade_rules_f.maximum%TYPE;
469: l_dummy_return_value pay_grade_rules_f.value%TYPE;
470: l_min_max_status varchar2(30);
471: l_uom pay_rates.rate_uom%TYPE;
472: l_currency_code per_business_groups.currency_code%TYPE;
473: --
474: cursor csel1 is
475: select pr.rate_uom
476: , pbg.currency_code

Line 477: from per_business_groups pbg

473: --
474: cursor csel1 is
475: select pr.rate_uom
476: , pbg.currency_code
477: from per_business_groups pbg
478: , pay_rates pr
479: where pr.rate_id = p_rate_id
480: and pbg.business_group_id = pr.business_group_id;
481: --

Line 646: l_currency_code per_business_groups.currency_code%TYPE;

642: l_mid_value pay_grade_rules_f.mid_value%TYPE;
643: l_dummy_return_value pay_grade_rules_f.value%TYPE;
644: l_min_max_status varchar2(30);
645: l_uom pay_rates.rate_uom%TYPE;
646: l_currency_code per_business_groups.currency_code%TYPE;
647: --
648: cursor csel1 is
649: select pr.rate_uom
650: , pbg.currency_code

Line 651: from per_business_groups pbg

647: --
648: cursor csel1 is
649: select pr.rate_uom
650: , pbg.currency_code
651: from per_business_groups pbg
652: , pay_rates pr
653: where pr.rate_id = p_rate_id
654: and pbg.business_group_id = pr.business_group_id;
655: --

Line 811: l_currency_code per_business_groups.currency_code%TYPE;

807: l_value pay_grade_rules_f.value%TYPE;
808: l_dummy_return_value pay_grade_rules_f.value%TYPE;
809: l_min_max_status varchar2(30);
810: l_uom pay_rates.rate_uom%TYPE;
811: l_currency_code per_business_groups.currency_code%TYPE;
812: --
813: cursor csel1 is
814: select pr.rate_uom
815: , pbg.currency_code

Line 816: from per_business_groups pbg

812: --
813: cursor csel1 is
814: select pr.rate_uom
815: , pbg.currency_code
816: from per_business_groups pbg
817: , pay_rates pr
818: where pr.rate_id = p_rate_id
819: and pbg.business_group_id = pr.business_group_id;
820: --

Line 1115: l_currency_code per_business_groups.currency_code%TYPE;

1111: l_value pay_grade_rules_f.value%TYPE;
1112: l_dummy_return_value pay_grade_rules_f.value%TYPE;
1113: l_min_max_status varchar2(30);
1114: l_uom pay_rates.rate_uom%TYPE;
1115: l_currency_code per_business_groups.currency_code%TYPE;
1116: --
1117: cursor csel1 is
1118: select pr.rate_uom
1119: , pbg.currency_code

Line 1120: from per_business_groups pbg

1116: --
1117: cursor csel1 is
1118: select pr.rate_uom
1119: , pbg.currency_code
1120: from per_business_groups pbg
1121: , pay_rates pr
1122: where pr.rate_id = p_rate_id
1123: and pbg.business_group_id = pr.business_group_id;
1124: --

Line 1848: from per_business_groups pbg

1844: -- Declare cursor
1845: --
1846: cursor csr_leg_code is
1847: select pbg.legislation_code
1848: from per_business_groups pbg
1849: , pay_grade_rules_f pgr
1850: where pgr.grade_rule_id = p_grade_rule_id
1851: and pbg.business_group_id = pgr.business_group_id
1852: order by pgr.effective_start_date;