[Home] [Help]
68: ,cp_effective_date DATE
69: )
70: IS
71: SELECT pur.user_row_id,pur.row_low_range_or_name,put.user_table_id
72: FROM pay_user_tables put
73: ,pay_user_rows_f pur
74: WHERE put.range_or_match = 'M'
75: AND put.user_table_name ='PQP_TRAVEL_PURPOSE'
76: AND put.user_table_id = pur.user_table_id
113: ,cp_effective_date DATE
114: )
115: IS
116: SELECT put.user_table_id
117: FROM pay_user_tables put
118: WHERE put.user_table_name = cp_rate_table_name
119: AND put.business_group_id = cp_business_group_id;
120:
121: l_get_column_info c_get_column_info%ROWTYPE;
459:
460: CURSOR c_get_rate_id(cp_user_table_name VARCHAR2)
461: IS
462: SELECT user_table_id
463: from pay_user_tables put
464: WHERE user_table_name=cp_user_table_name
465: AND put.business_group_id =p_business_group_id;
466:
467: l_get_default_value c_get_default_value%ROWTYPE;
878: l_get_ele_link c_get_ele_link%ROWTYPE;
879: l_effective_date DATE;
880: l_element_type_id pay_element_types_f.element_type_id%TYPE;
881: l_element_link_id pay_element_links_f.element_link_id%TYPE;
882: l_rates_table_id VARCHAR2(80); --pay_user_tables.user_table_id%TYPE;
883: l_get_element_type_id pqp_configuration_values.pcv_information5%TYPE;
884: l_get_rate_id pqp_configuration_values.pcv_information6%TYPE;
885: l_chk_eligibility VARCHAR2(1);
886: l_chk_mndtry VARCHAR2(1);
897: l_st_dt DATE;
898: l_ed_dt DATE;
899: l_user_type VARCHAR2(3);
900: l_purp_element_name pay_element_types_f.element_name%TYPE;
901: l_purp_rates_table_id pay_user_tables.user_table_id%TYPE;
902: l_purp_rates_table pay_user_tables.user_table_name%TYPE;
903: l_purp_taxable VARCHAR2(3);
904: l_sliding_rates VARCHAR2(1);
905: l_paye_taxable VARCHAR2(3);
898: l_ed_dt DATE;
899: l_user_type VARCHAR2(3);
900: l_purp_element_name pay_element_types_f.element_name%TYPE;
901: l_purp_rates_table_id pay_user_tables.user_table_id%TYPE;
902: l_purp_rates_table pay_user_tables.user_table_name%TYPE;
903: l_purp_taxable VARCHAR2(3);
904: l_sliding_rates VARCHAR2(1);
905: l_paye_taxable VARCHAR2(3);
906: BEGIN
1418: ,cp_business_group_id NUMBER
1419: )
1420: IS
1421: SELECT put.user_table_name
1422: FROM pay_user_tables put
1423: WHERE user_table_id =cp_user_rates_table
1424: AND put.business_group_id=cp_business_group_id;
1425:
1426:
2421: --
2422: CURSOR c_get_rates_table_id
2423: IS
2424: select user_table_id
2425: from pay_user_tables
2426: where range_or_match = 'M'
2427: and user_table_name = p_field;
2428:
2429: l_field varchar2(100);
2469: --
2470: CURSOR c_get_rates_table_name
2471: IS
2472: select user_table_name
2473: from pay_user_tables
2474: where user_table_id = p_field_id;
2475:
2476: CURSOR c_get_purpose_name
2477: IS
2475:
2476: CURSOR c_get_purpose_name
2477: IS
2478: SELECT pur.row_low_range_or_name
2479: FROM pay_user_tables put
2480: ,pay_user_rows_f pur
2481: WHERE put.range_or_match = 'M'
2482: AND put.user_table_name ='PQP_TRAVEL_PURPOSE'
2483: AND put.user_table_id = pur.user_table_id
2597:
2598: CURSOR c_get_purpose_name
2599: IS
2600: SELECT pur.row_low_range_or_name
2601: FROM pay_user_tables put
2602: ,pay_user_rows_f pur
2603: WHERE put.range_or_match = 'M'
2604: AND put.user_table_name ='PQP_TRAVEL_PURPOSE'
2605: AND put.user_table_id = pur.user_table_id
2922: ,cp_business_group_id NUMBER
2923: )
2924: IS
2925: SELECT put.user_table_name
2926: FROM pay_user_tables put
2927: WHERE user_table_id =cp_user_rates_table
2928: AND put.business_group_id=cp_business_group_id;
2929:
2930: CURSOR c_get_input_details (cp_element_type_id NUMBER
3237: ,cp_business_group_id NUMBER
3238: )
3239: IS
3240: SELECT put.user_table_name
3241: FROM pay_user_tables put
3242: WHERE user_table_id =cp_user_rates_table
3243: AND put.business_group_id=cp_business_group_id;
3244: l_effective_start_date DATE;
3245: l_effective_end_date DATE;