APPS.PAY_GB_EOY_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 103: g_category_input_id pay_input_values_f.input_value_id%TYPE;

99: g_ni_arrears_id pay_defined_balances.defined_balance_id%TYPE;
100: g_paye_details_id pay_element_types_f.element_type_id%TYPE;
101: g_paye_element_id pay_element_types_f.element_type_id%TYPE;
102: g_ni_id pay_element_types_f.element_type_id%TYPE;
103: g_category_input_id pay_input_values_f.input_value_id%TYPE;
104: g_scon_input_id pay_input_values_f.input_value_id%TYPE;
105: g_process_type_id pay_input_values_f.input_value_id%TYPE;
106: --
107: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;

Line 104: g_scon_input_id pay_input_values_f.input_value_id%TYPE;

100: g_paye_details_id pay_element_types_f.element_type_id%TYPE;
101: g_paye_element_id pay_element_types_f.element_type_id%TYPE;
102: g_ni_id pay_element_types_f.element_type_id%TYPE;
103: g_category_input_id pay_input_values_f.input_value_id%TYPE;
104: g_scon_input_id pay_input_values_f.input_value_id%TYPE;
105: g_process_type_id pay_input_values_f.input_value_id%TYPE;
106: --
107: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;
108: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;

Line 105: g_process_type_id pay_input_values_f.input_value_id%TYPE;

101: g_paye_element_id pay_element_types_f.element_type_id%TYPE;
102: g_ni_id pay_element_types_f.element_type_id%TYPE;
103: g_category_input_id pay_input_values_f.input_value_id%TYPE;
104: g_scon_input_id pay_input_values_f.input_value_id%TYPE;
105: g_process_type_id pay_input_values_f.input_value_id%TYPE;
106: --
107: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;
108: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;
109: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;

Line 375: FROM pay_input_values_f

371: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
372: --
373: SELECT input_value_id
374: INTO g_category_input_id
375: FROM pay_input_values_f
376: WHERE name = 'Category'
377: AND element_type_id = g_ni_id
378: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
379: --

Line 382: FROM pay_input_values_f

378: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
379: --
380: SELECT input_value_id
381: INTO g_scon_input_id
382: FROM pay_input_values_f
383: WHERE name = 'SCON'
384: AND element_type_id = g_ni_id
385: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
386: END IF;

Line 2766: FROM pay_input_values_f

2762: AND g_end_year BETWEEN effective_start_date AND effective_end_date;
2763: --
2764: SELECT input_value_id
2765: INTO g_category_input_id
2766: FROM pay_input_values_f
2767: WHERE name = 'Category'
2768: AND element_type_id = g_ni_id
2769: AND g_end_year BETWEEN effective_start_date AND effective_end_date;
2770: --

Line 2773: FROM pay_input_values_f

2769: AND g_end_year BETWEEN effective_start_date AND effective_end_date;
2770: --
2771: SELECT input_value_id
2772: INTO g_process_type_id
2773: FROM pay_input_values_f
2774: WHERE name = 'Process Type'
2775: AND element_type_id = g_ni_id
2776: AND g_end_year BETWEEN effective_start_date AND effective_end_date;
2777: --

Line 2781: FROM pay_input_values_f

2777: --
2778: /* EOY 2012/2013 changes
2779: SELECT input_value_id
2780: INTO g_scon_input_id
2781: FROM pay_input_values_f
2782: WHERE name = 'SCON'
2783: AND element_type_id = g_ni_id
2784: AND g_end_year BETWEEN effective_start_date AND effective_end_date;
2785: -- */

Line 3822: pay_input_values_f iv,

3818: fnd_number.canonical_to_number(screen_entry_value),NULL))
3819: tax_previous
3820: FROM pay_element_entries_f e,
3821: pay_element_entry_values_f v,
3822: pay_input_values_f iv,
3823: pay_element_links_f link
3824: WHERE e.assignment_id = p_assignment_id
3825: AND link.element_type_id = g_paye_details_id
3826: AND e.element_link_id = link.element_link_id

Line 3848: FROM pay_input_values_f v,

3844: pay_previous,
3845: 100 * to_number(max(decode(name,'Tax Previous',
3846: fnd_number.canonical_to_number(result_value),NULL)))
3847: tax_previous
3848: FROM pay_input_values_f v,
3849: pay_run_result_values rrv
3850: WHERE rrv.run_result_id = p_tax_run_result_id
3851: AND v.input_value_id = rrv.input_value_id
3852: AND v.element_type_id = g_paye_details_id;

Line 3863: FROM pay_input_values_f v,

3859: pay_previous,
3860: 100 * to_number(max(decode(name,'Tax Previous',
3861: fnd_number.canonical_to_number(result_value),NULL)))
3862: tax_previous
3863: FROM pay_input_values_f v,
3864: pay_run_result_values rrv
3865: WHERE rrv.run_result_id = p_tax_run_result_id
3866: AND v.input_value_id = rrv.input_value_id
3867: AND v.element_type_id = g_paye_element_id;