APPS.PAY_NZ_SSCWT_RATE_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 25: g_input_value_id pay_input_values_f.input_value_id%TYPE ;

21: g_financial_year DATE;
22: g_processing_mode VARCHAR2(1);
23:
24: g_element_type_id pay_element_types_f.element_type_id%TYPE ;
25: g_input_value_id pay_input_values_f.input_value_id%TYPE ;
26:
27: g_def_balance_tab pay_balance_pkg.t_balance_value_tab;
28:
29: g_start_dd_mm VARCHAR(6) ;

Line 759: ,pay_input_values_f piv

755: CURSOR csr_get_element_ids(c_financial_year DATE)
756: IS
757: SELECT pet.element_type_id, piv.input_value_id
758: FROM pay_element_types_f pet
759: ,pay_input_values_f piv
760: WHERE pet.element_name = 'SSCWT Information'
761: AND pet.element_type_id = piv.element_type_id
762: AND piv.name = 'SSCWT Rate'
763: AND c_financial_year BETWEEN pet.effective_start_date

Line 1018: (c_input_value_id pay_input_values_f.input_value_id%TYPE

1014: AND pay_action.effective_date BETWEEN add_months(c_financial_year,-12)
1015: AND c_financial_year-1);
1016: --
1017: CURSOR csr_get_old_sscwt_rate
1018: (c_input_value_id pay_input_values_f.input_value_id%TYPE
1019: ,c_element_type_id pay_input_values_f.element_type_id%TYPE
1020: ,c_assignment_id per_assignments_f.assignment_id%TYPE )
1021: IS
1022: SELECT DECODE(inputv.hot_default_flag,'Y'

Line 1019: ,c_element_type_id pay_input_values_f.element_type_id%TYPE

1015: AND c_financial_year-1);
1016: --
1017: CURSOR csr_get_old_sscwt_rate
1018: (c_input_value_id pay_input_values_f.input_value_id%TYPE
1019: ,c_element_type_id pay_input_values_f.element_type_id%TYPE
1020: ,c_assignment_id per_assignments_f.assignment_id%TYPE )
1021: IS
1022: SELECT DECODE(inputv.hot_default_flag,'Y'
1023: ,NVL(entry_value.screen_entry_value, NVL(link.default_value

Line 1029: pay_input_values_f inputv

1025: ,entry.element_entry_id element_entry_id
1026: FROM pay_element_entry_values_f entry_value,
1027: pay_element_entries_f entry,
1028: pay_link_input_values_f link,
1029: pay_input_values_f inputv
1030: WHERE inputv.input_value_id = c_input_value_id
1031: AND g_financial_year between inputv.effective_start_date
1032: and inputv.effective_end_date
1033: AND inputv.element_type_id + 0 = c_element_type_id