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_GB_PENSION_SCHEME_TEMPLATE dependencies on PQP_PENSION_TYPES_F

Line 8: pension_type_id pqp_pension_types_f.pension_type_id%TYPE

4: g_proc_name VARCHAR2 (80)
5: := 'pqp_gb_pension_scheme_template.';
6:
7: TYPE r_pension_types IS RECORD (
8: pension_type_id pqp_pension_types_f.pension_type_id%TYPE
9: ,pension_type_name pqp_pension_types_f.pension_type_name%TYPE
10: ,effective_start_date pqp_pension_types_f.effective_start_date%TYPE
11: ,effective_end_date pqp_pension_types_f.effective_end_date%TYPE
12: ,pension_category pqp_pension_types_f.pension_category%TYPE

Line 9: ,pension_type_name pqp_pension_types_f.pension_type_name%TYPE

5: := 'pqp_gb_pension_scheme_template.';
6:
7: TYPE r_pension_types IS RECORD (
8: pension_type_id pqp_pension_types_f.pension_type_id%TYPE
9: ,pension_type_name pqp_pension_types_f.pension_type_name%TYPE
10: ,effective_start_date pqp_pension_types_f.effective_start_date%TYPE
11: ,effective_end_date pqp_pension_types_f.effective_end_date%TYPE
12: ,pension_category pqp_pension_types_f.pension_category%TYPE
13: ,ee_contribution_percent pqp_pension_types_f.ee_contribution_percent%TYPE

Line 10: ,effective_start_date pqp_pension_types_f.effective_start_date%TYPE

6:
7: TYPE r_pension_types IS RECORD (
8: pension_type_id pqp_pension_types_f.pension_type_id%TYPE
9: ,pension_type_name pqp_pension_types_f.pension_type_name%TYPE
10: ,effective_start_date pqp_pension_types_f.effective_start_date%TYPE
11: ,effective_end_date pqp_pension_types_f.effective_end_date%TYPE
12: ,pension_category pqp_pension_types_f.pension_category%TYPE
13: ,ee_contribution_percent pqp_pension_types_f.ee_contribution_percent%TYPE
14: ,er_contribution_percent pqp_pension_types_f.er_contribution_percent%TYPE

Line 11: ,effective_end_date pqp_pension_types_f.effective_end_date%TYPE

7: TYPE r_pension_types IS RECORD (
8: pension_type_id pqp_pension_types_f.pension_type_id%TYPE
9: ,pension_type_name pqp_pension_types_f.pension_type_name%TYPE
10: ,effective_start_date pqp_pension_types_f.effective_start_date%TYPE
11: ,effective_end_date pqp_pension_types_f.effective_end_date%TYPE
12: ,pension_category pqp_pension_types_f.pension_category%TYPE
13: ,ee_contribution_percent pqp_pension_types_f.ee_contribution_percent%TYPE
14: ,er_contribution_percent pqp_pension_types_f.er_contribution_percent%TYPE
15: ,ee_contribution_fixed_rate pqp_pension_types_f.ee_contribution_fixed_rate%TYPE

Line 12: ,pension_category pqp_pension_types_f.pension_category%TYPE

8: pension_type_id pqp_pension_types_f.pension_type_id%TYPE
9: ,pension_type_name pqp_pension_types_f.pension_type_name%TYPE
10: ,effective_start_date pqp_pension_types_f.effective_start_date%TYPE
11: ,effective_end_date pqp_pension_types_f.effective_end_date%TYPE
12: ,pension_category pqp_pension_types_f.pension_category%TYPE
13: ,ee_contribution_percent pqp_pension_types_f.ee_contribution_percent%TYPE
14: ,er_contribution_percent pqp_pension_types_f.er_contribution_percent%TYPE
15: ,ee_contribution_fixed_rate pqp_pension_types_f.ee_contribution_fixed_rate%TYPE
16: ,er_contribution_fixed_rate pqp_pension_types_f.er_contribution_fixed_rate%TYPE

Line 13: ,ee_contribution_percent pqp_pension_types_f.ee_contribution_percent%TYPE

9: ,pension_type_name pqp_pension_types_f.pension_type_name%TYPE
10: ,effective_start_date pqp_pension_types_f.effective_start_date%TYPE
11: ,effective_end_date pqp_pension_types_f.effective_end_date%TYPE
12: ,pension_category pqp_pension_types_f.pension_category%TYPE
13: ,ee_contribution_percent pqp_pension_types_f.ee_contribution_percent%TYPE
14: ,er_contribution_percent pqp_pension_types_f.er_contribution_percent%TYPE
15: ,ee_contribution_fixed_rate pqp_pension_types_f.ee_contribution_fixed_rate%TYPE
16: ,er_contribution_fixed_rate pqp_pension_types_f.er_contribution_fixed_rate%TYPE
17: ,ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%TYPE

Line 14: ,er_contribution_percent pqp_pension_types_f.er_contribution_percent%TYPE

10: ,effective_start_date pqp_pension_types_f.effective_start_date%TYPE
11: ,effective_end_date pqp_pension_types_f.effective_end_date%TYPE
12: ,pension_category pqp_pension_types_f.pension_category%TYPE
13: ,ee_contribution_percent pqp_pension_types_f.ee_contribution_percent%TYPE
14: ,er_contribution_percent pqp_pension_types_f.er_contribution_percent%TYPE
15: ,ee_contribution_fixed_rate pqp_pension_types_f.ee_contribution_fixed_rate%TYPE
16: ,er_contribution_fixed_rate pqp_pension_types_f.er_contribution_fixed_rate%TYPE
17: ,ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%TYPE
18: ,er_contribution_bal_type_id pqp_pension_types_f.er_contribution_bal_type_id%TYPE);

Line 15: ,ee_contribution_fixed_rate pqp_pension_types_f.ee_contribution_fixed_rate%TYPE

11: ,effective_end_date pqp_pension_types_f.effective_end_date%TYPE
12: ,pension_category pqp_pension_types_f.pension_category%TYPE
13: ,ee_contribution_percent pqp_pension_types_f.ee_contribution_percent%TYPE
14: ,er_contribution_percent pqp_pension_types_f.er_contribution_percent%TYPE
15: ,ee_contribution_fixed_rate pqp_pension_types_f.ee_contribution_fixed_rate%TYPE
16: ,er_contribution_fixed_rate pqp_pension_types_f.er_contribution_fixed_rate%TYPE
17: ,ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%TYPE
18: ,er_contribution_bal_type_id pqp_pension_types_f.er_contribution_bal_type_id%TYPE);
19:

Line 16: ,er_contribution_fixed_rate pqp_pension_types_f.er_contribution_fixed_rate%TYPE

12: ,pension_category pqp_pension_types_f.pension_category%TYPE
13: ,ee_contribution_percent pqp_pension_types_f.ee_contribution_percent%TYPE
14: ,er_contribution_percent pqp_pension_types_f.er_contribution_percent%TYPE
15: ,ee_contribution_fixed_rate pqp_pension_types_f.ee_contribution_fixed_rate%TYPE
16: ,er_contribution_fixed_rate pqp_pension_types_f.er_contribution_fixed_rate%TYPE
17: ,ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%TYPE
18: ,er_contribution_bal_type_id pqp_pension_types_f.er_contribution_bal_type_id%TYPE);
19:
20: TYPE t_pension_types IS TABLE OF r_pension_types

Line 17: ,ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%TYPE

13: ,ee_contribution_percent pqp_pension_types_f.ee_contribution_percent%TYPE
14: ,er_contribution_percent pqp_pension_types_f.er_contribution_percent%TYPE
15: ,ee_contribution_fixed_rate pqp_pension_types_f.ee_contribution_fixed_rate%TYPE
16: ,er_contribution_fixed_rate pqp_pension_types_f.er_contribution_fixed_rate%TYPE
17: ,ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%TYPE
18: ,er_contribution_bal_type_id pqp_pension_types_f.er_contribution_bal_type_id%TYPE);
19:
20: TYPE t_pension_types IS TABLE OF r_pension_types
21: INDEX BY BINARY_INTEGER;

Line 18: ,er_contribution_bal_type_id pqp_pension_types_f.er_contribution_bal_type_id%TYPE);

14: ,er_contribution_percent pqp_pension_types_f.er_contribution_percent%TYPE
15: ,ee_contribution_fixed_rate pqp_pension_types_f.ee_contribution_fixed_rate%TYPE
16: ,er_contribution_fixed_rate pqp_pension_types_f.er_contribution_fixed_rate%TYPE
17: ,ee_contribution_bal_type_id pqp_pension_types_f.ee_contribution_bal_type_id%TYPE
18: ,er_contribution_bal_type_id pqp_pension_types_f.er_contribution_bal_type_id%TYPE);
19:
20: TYPE t_pension_types IS TABLE OF r_pension_types
21: INDEX BY BINARY_INTEGER;
22:

Line 766: FROM pqp_pension_types_f

762: ,effective_end_date, pension_category
763: ,ee_contribution_percent, er_contribution_percent
764: ,ee_contribution_fixed_rate, er_contribution_fixed_rate
765: ,ee_contribution_bal_type_id, er_contribution_bal_type_id
766: FROM pqp_pension_types_f
767: WHERE pension_type_id = p_pension_type_id
768: AND p_effective_start_date BETWEEN effective_start_date
769: AND effective_end_date
770: AND ( ( business_group_id IS NOT NULL