DBA Data[Home] [Help]

APPS.PQP_PENSION_TYPES_API dependencies on PAY_INPUT_VALUES_F

Line 903: l_ipv_ee_contr pay_input_values_f.input_value_id%TYPE;

899: l_row_id rowid;
900: l_count number :=0;
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:

Line 904: l_ipv_er_contr pay_input_values_f.input_value_id%TYPE;

900: l_count number :=0;
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

Line 2486: From pay_input_values_f

2482: Cursor csr_get_ipv_info
2483: Is
2484: Select input_value_id
2485: ,object_version_number
2486: From pay_input_values_f
2487: Where element_type_id = p_balance_init_ele_type_id
2488: And p_effective_date Between effective_start_date
2489: And effective_end_date;
2490: