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 27: from per_business_groups_perf

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

Line 61: l_legislation_code per_business_groups.legislation_code%TYPE;

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

Line 222: from per_business_groups_perf

218: ) Is
219:
220: Cursor csr_bg Is
221: Select currency_code,legislation_code,name
222: from per_business_groups_perf
223: where business_group_id = p_business_group_id;
224:
225: Cursor csr_bal_name(c_balance_name in varchar2) Is
226: Select 'x'

Line 256: l_legislation_code per_business_groups.legislation_code%TYPE;

252: l_bal_name_exists varchar2(3);
253: l_row_id rowid;
254: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
255: l_currency_code pay_balance_types.currency_code%TYPE;
256: l_legislation_code per_business_groups.legislation_code%TYPE;
257: l_balance_name pay_balance_types.balance_name%TYPE;
258: l_reporting_name pay_balance_types.reporting_name%TYPE;
259: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
260: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;

Line 417: from per_business_groups_perf

413: ) Is
414:
415: Cursor csr_bg Is
416: Select currency_code,legislation_code,name
417: from per_business_groups_perf
418: where business_group_id = p_business_group_id;
419:
420: Cursor csr_bal_name(c_balance_name in varchar2) Is
421: Select 'x'

Line 451: l_legislation_code per_business_groups.legislation_code%TYPE;

447: l_bal_name_exists varchar2(3);
448: l_row_id rowid;
449: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
450: l_currency_code pay_balance_types.currency_code%TYPE;
451: l_legislation_code per_business_groups.legislation_code%TYPE;
452: l_balance_name pay_balance_types.balance_name%TYPE;
453: l_reporting_name pay_balance_types.reporting_name%TYPE;
454: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
455: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;

Line 650: from per_business_groups_perf

646: ) Is
647:
648: Cursor csr_bg Is
649: Select currency_code,legislation_code,name
650: from per_business_groups_perf
651: where business_group_id = p_business_group_id;
652:
653: Cursor csr_bal_typ_id(c_balance_name in varchar2) Is
654: Select balance_type_id

Line 683: l_legislation_code per_business_groups.legislation_code%TYPE;

679: l_proc varchar2(150) := g_package||'Create_ABP_EE_ER_Balances';
680: l_row_id rowid;
681: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
682: l_currency_code pay_balance_types.currency_code%TYPE;
683: l_legislation_code per_business_groups.legislation_code%TYPE;
684: l_balance_name pay_balance_types.balance_name%TYPE;
685: l_reporting_name pay_balance_types.reporting_name%TYPE;
686: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
687: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;

Line 905: l_business_group_name per_business_groups.name%TYPE;

901: l_proc varchar2(150) := g_package||'Create_Balance_Init_Ele';
902: l_balance_feed_Id pay_balance_feeds_f.balance_feed_id%TYPE;
903: l_ipv_ee_contr pay_input_values_f.input_value_id%TYPE;
904: l_ipv_er_contr pay_input_values_f.input_value_id%TYPE;
905: l_business_group_name per_business_groups.name%TYPE;
906: l_pension_sub_cat_mean varchar2(80) := '';
907:
908: Begin
909: hr_utility.set_location(' Entering:'|| l_proc, 10);

Line 1244: FROM per_business_groups

1240: --
1241:
1242: CURSOR c_get_leg_code IS
1243: SELECT legislation_code
1244: FROM per_business_groups
1245: WHERE business_group_id = p_business_group_id;
1246:
1247: l_proc varchar2(150) := g_package||'Create_Pension_Type';
1248: l_effective_date date;