APPS.PAY_GB_EOY_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 100: g_paye_details_id pay_element_types_f.element_type_id%TYPE;

96: g_widow_id pay_defined_balances.defined_balance_id%TYPE;
97: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
98: g_taxable_id pay_defined_balances.defined_balance_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;

Line 101: g_paye_element_id pay_element_types_f.element_type_id%TYPE;

97: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
98: g_taxable_id pay_defined_balances.defined_balance_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;

Line 102: g_ni_id pay_element_types_f.element_type_id%TYPE;

98: g_taxable_id pay_defined_balances.defined_balance_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: --

Line 369: FROM pay_element_types_f

365: /* 4502181- IF globals are null, query them here -- Required by the Tax Payments Listing report */
366: IF G_NI_ID IS NULL THEN
367: SELECT element_type_id
368: INTO g_ni_id
369: FROM pay_element_types_f
370: WHERE element_name = 'NI'
371: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
372: --
373: SELECT input_value_id

Line 2748: FROM pay_element_types_f

2744: CLOSE get_defined_balance_id;
2745: --
2746: SELECT element_type_id
2747: INTO g_paye_details_id
2748: FROM pay_element_types_f
2749: WHERE element_name = 'PAYE Details'
2750: AND g_end_year BETWEEN effective_start_date AND effective_end_date;
2751: --
2752: SELECT element_type_id

Line 2754: FROM pay_element_types_f

2750: AND g_end_year BETWEEN effective_start_date AND effective_end_date;
2751: --
2752: SELECT element_type_id
2753: INTO g_paye_element_id
2754: FROM pay_element_types_f
2755: WHERE element_name = 'PAYE'
2756: AND g_end_year BETWEEN effective_start_date AND effective_end_date;
2757: --
2758: SELECT element_type_id

Line 2760: FROM pay_element_types_f

2756: AND g_end_year BETWEEN effective_start_date AND effective_end_date;
2757: --
2758: SELECT element_type_id
2759: INTO g_ni_id
2760: FROM pay_element_types_f
2761: WHERE element_name = 'NI'
2762: AND g_end_year BETWEEN effective_start_date AND effective_end_date;
2763: --
2764: SELECT input_value_id