APPS.PAY_GB_EOY_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 87: g_paye_details_id pay_element_types_f.element_type_id%TYPE;

83: g_widow_id pay_defined_balances.defined_balance_id%TYPE;
84: g_student_loan_id pay_defined_balances.defined_balance_id%TYPE;
85: g_taxable_id pay_defined_balances.defined_balance_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;

Line 88: g_paye_element_id pay_element_types_f.element_type_id%TYPE;

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

Line 89: g_ni_id pay_element_types_f.element_type_id%TYPE;

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

Line 345: FROM pay_element_types_f

341: /* 4502181- IF globals are null, query them here -- Required by the Tax Payments Listing report */
342: IF G_NI_ID IS NULL THEN
343: SELECT element_type_id
344: INTO g_ni_id
345: FROM pay_element_types_f
346: WHERE element_name = 'NI'
347: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
348: --
349: SELECT input_value_id

Line 2654: FROM pay_element_types_f

2650: CLOSE get_defined_balance_id;
2651: --
2652: SELECT element_type_id
2653: INTO g_paye_details_id
2654: FROM pay_element_types_f
2655: WHERE element_name = 'PAYE Details'
2656: AND g_end_year BETWEEN effective_start_date AND effective_end_date;
2657: --
2658: SELECT element_type_id

Line 2660: FROM pay_element_types_f

2656: AND g_end_year BETWEEN effective_start_date AND effective_end_date;
2657: --
2658: SELECT element_type_id
2659: INTO g_paye_element_id
2660: FROM pay_element_types_f
2661: WHERE element_name = 'PAYE'
2662: AND g_end_year BETWEEN effective_start_date AND effective_end_date;
2663: --
2664: SELECT element_type_id

Line 2666: FROM pay_element_types_f

2662: AND g_end_year BETWEEN effective_start_date AND effective_end_date;
2663: --
2664: SELECT element_type_id
2665: INTO g_ni_id
2666: FROM pay_element_types_f
2667: WHERE element_name = 'NI'
2668: AND g_end_year BETWEEN effective_start_date AND effective_end_date;
2669: --
2670: SELECT input_value_id