DBA Data[Home] [Help]

APPS.PQP_PENSION_TYPES_API dependencies on PAY_INPUT_VALUES_F

Line 834: l_ipv_ee_contr pay_input_values_f.input_value_id%TYPE;

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

Line 835: l_ipv_er_contr pay_input_values_f.input_value_id%TYPE;

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

Line 2413: From pay_input_values_f

2409: Cursor csr_get_ipv_info
2410: Is
2411: Select input_value_id
2412: ,object_version_number
2413: From pay_input_values_f
2414: Where element_type_id = p_balance_init_ele_type_id
2415: And p_effective_date Between effective_start_date
2416: And effective_end_date;
2417: