eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_PENSION_TYPES_API dependencies on PER_BUSINESS_GROUPS

Line 7: g_bg_grp_id per_business_groups.business_group_id%TYPE;

3: --
4: -- Package Variables
5: --
6: g_package varchar2(50) := ' pqp_pension_types_api.';
7: g_bg_grp_id per_business_groups.business_group_id%TYPE;
8: g_bg_grp_name per_business_groups.name%TYPE;
9: g_leg_code per_business_groups.legislation_code%TYPE;
10: g_currency_code per_business_groups.currency_code%TYPE;
11:

Line 8: g_bg_grp_name per_business_groups.name%TYPE;

4: -- Package Variables
5: --
6: g_package varchar2(50) := ' pqp_pension_types_api.';
7: g_bg_grp_id per_business_groups.business_group_id%TYPE;
8: g_bg_grp_name per_business_groups.name%TYPE;
9: g_leg_code per_business_groups.legislation_code%TYPE;
10: g_currency_code per_business_groups.currency_code%TYPE;
11:
12:

Line 9: g_leg_code per_business_groups.legislation_code%TYPE;

5: --
6: g_package varchar2(50) := ' pqp_pension_types_api.';
7: g_bg_grp_id per_business_groups.business_group_id%TYPE;
8: g_bg_grp_name per_business_groups.name%TYPE;
9: g_leg_code per_business_groups.legislation_code%TYPE;
10: g_currency_code per_business_groups.currency_code%TYPE;
11:
12:
13: -- ---------------------------------------------------------------------------

Line 10: g_currency_code per_business_groups.currency_code%TYPE;

6: g_package varchar2(50) := ' pqp_pension_types_api.';
7: g_bg_grp_id per_business_groups.business_group_id%TYPE;
8: g_bg_grp_name per_business_groups.name%TYPE;
9: g_leg_code per_business_groups.legislation_code%TYPE;
10: g_currency_code per_business_groups.currency_code%TYPE;
11:
12:
13: -- ---------------------------------------------------------------------------
14: -- |------------------------< Create_EE_Balance >-------------------------|

Line 26: from per_business_groups_perf

22: ) Is
23:
24: Cursor csr_bg Is
25: Select currency_code,legislation_code,name
26: from per_business_groups_perf
27: where business_group_id = p_business_group_id;
28:
29: Cursor csr_bal_name(c_balance_name in varchar2) Is
30: Select 'x'

Line 60: l_legislation_code per_business_groups.legislation_code%TYPE;

56: l_bal_name_exists varchar2(3);
57: l_row_id rowid;
58: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
59: l_currency_code pay_balance_types.currency_code%TYPE;
60: l_legislation_code per_business_groups.legislation_code%TYPE;
61: l_balance_name pay_balance_types.balance_name%TYPE;
62: l_reporting_name pay_balance_types.reporting_name%TYPE;
63: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
64: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;

Line 207: from per_business_groups_perf

203: ) Is
204:
205: Cursor csr_bg Is
206: Select currency_code,legislation_code,name
207: from per_business_groups_perf
208: where business_group_id = p_business_group_id;
209:
210: Cursor csr_bal_name(c_balance_name in varchar2) Is
211: Select 'x'

Line 241: l_legislation_code per_business_groups.legislation_code%TYPE;

237: l_bal_name_exists varchar2(3);
238: l_row_id rowid;
239: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
240: l_currency_code pay_balance_types.currency_code%TYPE;
241: l_legislation_code per_business_groups.legislation_code%TYPE;
242: l_balance_name pay_balance_types.balance_name%TYPE;
243: l_reporting_name pay_balance_types.reporting_name%TYPE;
244: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
245: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;

Line 388: from per_business_groups_perf

384: ) Is
385:
386: Cursor csr_bg Is
387: Select currency_code,legislation_code,name
388: from per_business_groups_perf
389: where business_group_id = p_business_group_id;
390:
391: Cursor csr_bal_name(c_balance_name in varchar2) Is
392: Select 'x'

Line 422: l_legislation_code per_business_groups.legislation_code%TYPE;

418: l_bal_name_exists varchar2(3);
419: l_row_id rowid;
420: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
421: l_currency_code pay_balance_types.currency_code%TYPE;
422: l_legislation_code per_business_groups.legislation_code%TYPE;
423: l_balance_name pay_balance_types.balance_name%TYPE;
424: l_reporting_name pay_balance_types.reporting_name%TYPE;
425: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
426: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;

Line 597: from per_business_groups_perf

593: ) Is
594:
595: Cursor csr_bg Is
596: Select currency_code,legislation_code,name
597: from per_business_groups_perf
598: where business_group_id = p_business_group_id;
599:
600: Cursor csr_bal_typ_id(c_balance_name in varchar2) Is
601: Select balance_type_id

Line 621: l_legislation_code per_business_groups.legislation_code%TYPE;

617: l_proc varchar2(150) := g_package||'Create_ABP_EE_ER_Balances';
618: l_row_id rowid;
619: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
620: l_currency_code pay_balance_types.currency_code%TYPE;
621: l_legislation_code per_business_groups.legislation_code%TYPE;
622: l_balance_name pay_balance_types.balance_name%TYPE;
623: l_reporting_name pay_balance_types.reporting_name%TYPE;
624: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
625: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;

Line 836: l_business_group_name per_business_groups.name%TYPE;

832: l_proc varchar2(150) := g_package||'Create_Balance_Init_Ele';
833: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%TYPE;
834: l_ipv_ee_contr pay_input_values_f.input_value_id%TYPE;
835: l_ipv_er_contr pay_input_values_f.input_value_id%TYPE;
836: l_business_group_name per_business_groups.name%TYPE;
837: l_pension_sub_cat_mean varchar2(80) := '';
838:
839: Begin
840: hr_utility.set_location(' Entering:'|| l_proc, 10);

Line 1175: FROM per_business_groups

1171: --
1172:
1173: CURSOR c_get_leg_code IS
1174: SELECT legislation_code
1175: FROM per_business_groups
1176: WHERE business_group_id = p_business_group_id;
1177:
1178: l_proc varchar2(150) := g_package||'Create_Pension_Type';
1179: l_effective_date date;