APPS.PAY_GB_EOY_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 90: g_category_input_id pay_input_values_f.input_value_id%TYPE;

86: g_ni_arrears_id pay_defined_balances.defined_balance_id%TYPE;
87: g_paye_details_id pay_element_types_f.element_type_id%TYPE;
88: g_paye_element_id pay_element_types_f.element_type_id%TYPE;
89: g_ni_id pay_element_types_f.element_type_id%TYPE;
90: g_category_input_id pay_input_values_f.input_value_id%TYPE;
91: g_scon_input_id pay_input_values_f.input_value_id%TYPE;
92: g_process_type_id pay_input_values_f.input_value_id%TYPE;
93: --
94: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;

Line 91: g_scon_input_id pay_input_values_f.input_value_id%TYPE;

87: g_paye_details_id pay_element_types_f.element_type_id%TYPE;
88: g_paye_element_id pay_element_types_f.element_type_id%TYPE;
89: g_ni_id pay_element_types_f.element_type_id%TYPE;
90: g_category_input_id pay_input_values_f.input_value_id%TYPE;
91: g_scon_input_id pay_input_values_f.input_value_id%TYPE;
92: g_process_type_id pay_input_values_f.input_value_id%TYPE;
93: --
94: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;
95: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;

Line 92: g_process_type_id pay_input_values_f.input_value_id%TYPE;

88: g_paye_element_id pay_element_types_f.element_type_id%TYPE;
89: g_ni_id pay_element_types_f.element_type_id%TYPE;
90: g_category_input_id pay_input_values_f.input_value_id%TYPE;
91: g_scon_input_id pay_input_values_f.input_value_id%TYPE;
92: g_process_type_id pay_input_values_f.input_value_id%TYPE;
93: --
94: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;
95: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;
96: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;

Line 351: FROM pay_input_values_f

347: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
348: --
349: SELECT input_value_id
350: INTO g_category_input_id
351: FROM pay_input_values_f
352: WHERE name = 'Category'
353: AND element_type_id = g_ni_id
354: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
355: --

Line 358: FROM pay_input_values_f

354: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
355: --
356: SELECT input_value_id
357: INTO g_scon_input_id
358: FROM pay_input_values_f
359: WHERE name = 'SCON'
360: AND element_type_id = g_ni_id
361: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
362: END IF;

Line 2672: FROM pay_input_values_f

2668: AND g_end_year BETWEEN effective_start_date AND effective_end_date;
2669: --
2670: SELECT input_value_id
2671: INTO g_category_input_id
2672: FROM pay_input_values_f
2673: WHERE name = 'Category'
2674: AND element_type_id = g_ni_id
2675: AND g_end_year BETWEEN effective_start_date AND effective_end_date;
2676: --

Line 2679: FROM pay_input_values_f

2675: AND g_end_year BETWEEN effective_start_date AND effective_end_date;
2676: --
2677: SELECT input_value_id
2678: INTO g_process_type_id
2679: FROM pay_input_values_f
2680: WHERE name = 'Process Type'
2681: AND element_type_id = g_ni_id
2682: AND g_end_year BETWEEN effective_start_date AND effective_end_date;
2683: --

Line 2686: FROM pay_input_values_f

2682: AND g_end_year BETWEEN effective_start_date AND effective_end_date;
2683: --
2684: SELECT input_value_id
2685: INTO g_scon_input_id
2686: FROM pay_input_values_f
2687: WHERE name = 'SCON'
2688: AND element_type_id = g_ni_id
2689: AND g_end_year BETWEEN effective_start_date AND effective_end_date;
2690: --

Line 3681: pay_input_values_f iv,

3677: fnd_number.canonical_to_number(screen_entry_value),NULL))
3678: tax_previous
3679: FROM pay_element_entries_f e,
3680: pay_element_entry_values_f v,
3681: pay_input_values_f iv,
3682: pay_element_links_f link
3683: WHERE e.assignment_id = p_assignment_id
3684: AND link.element_type_id = g_paye_details_id
3685: AND e.element_link_id = link.element_link_id

Line 3707: FROM pay_input_values_f v,

3703: pay_previous,
3704: 100 * to_number(max(decode(name,'Tax Previous',
3705: fnd_number.canonical_to_number(result_value),NULL)))
3706: tax_previous
3707: FROM pay_input_values_f v,
3708: pay_run_result_values rrv
3709: WHERE rrv.run_result_id = p_tax_run_result_id
3710: AND v.input_value_id = rrv.input_value_id
3711: AND v.element_type_id = g_paye_details_id;

Line 3722: FROM pay_input_values_f v,

3718: pay_previous,
3719: 100 * to_number(max(decode(name,'Tax Previous',
3720: fnd_number.canonical_to_number(result_value),NULL)))
3721: tax_previous
3722: FROM pay_input_values_f v,
3723: pay_run_result_values rrv
3724: WHERE rrv.run_result_id = p_tax_run_result_id
3725: AND v.input_value_id = rrv.input_value_id
3726: AND v.element_type_id = g_paye_element_id;