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 756: ,pay_input_values_f piv

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

Line 1003: (c_input_value_id pay_input_values_f.input_value_id%TYPE

999: AND pay_action.effective_date BETWEEN add_months(c_financial_year,-12)
1000: AND c_financial_year-1);
1001: --
1002: CURSOR csr_get_old_sscwt_rate
1003: (c_input_value_id pay_input_values_f.input_value_id%TYPE
1004: ,c_element_type_id pay_input_values_f.element_type_id%TYPE
1005: ,c_assignment_id per_assignments_f.assignment_id%TYPE )
1006: IS
1007: SELECT DECODE(inputv.hot_default_flag,'Y'

Line 1004: ,c_element_type_id pay_input_values_f.element_type_id%TYPE

1000: AND c_financial_year-1);
1001: --
1002: CURSOR csr_get_old_sscwt_rate
1003: (c_input_value_id pay_input_values_f.input_value_id%TYPE
1004: ,c_element_type_id pay_input_values_f.element_type_id%TYPE
1005: ,c_assignment_id per_assignments_f.assignment_id%TYPE )
1006: IS
1007: SELECT DECODE(inputv.hot_default_flag,'Y'
1008: ,NVL(entry_value.screen_entry_value, NVL(link.default_value

Line 1014: pay_input_values_f inputv

1010: ,entry.element_entry_id element_entry_id
1011: FROM pay_element_entry_values_f entry_value,
1012: pay_element_entries_f entry,
1013: pay_link_input_values_f link,
1014: pay_input_values_f inputv
1015: WHERE inputv.input_value_id = c_input_value_id
1016: AND g_financial_year between inputv.effective_start_date
1017: and inputv.effective_end_date
1018: AND inputv.element_type_id + 0 = c_element_type_id