APPS.PAY_P45_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 372: g_paye_details_id pay_element_types_f.element_type_id%TYPE;

368: -- Added for P45PT1. Bug 6345375
369: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;
370: g_sex_eid ff_user_entities.user_entity_id%TYPE;
371: -- Seed data IDs
372: g_paye_details_id pay_element_types_f.element_type_id%TYPE;
373: --
374: FUNCTION get_report_request_error RETURN VARCHAR2 IS
375: BEGIN
376: RETURN g_fnd_rep_request_msg;

Line 459: FROM pay_element_types_f pet,

455: --
456: cursor csr_getdate (x_assignment_id NUMBER,
457: x_termination_date DATE) IS
458: SELECT peev.screen_entry_value
459: FROM pay_element_types_f pet,
460: pay_element_links_f pel,
461: pay_element_entries_f pee,
462: pay_input_values_f piv,
463: pay_element_entry_values_f peev

Line 2130: pay_element_types_f type,

2126: -- c_effective_end_date in date) is --Bug 9036584
2127: select 1 from dual where exists
2128: (select prrv.result_value
2129: from pay_input_values_f inv,
2130: pay_element_types_f type,
2131: pay_run_results prr,
2132: pay_run_result_values prrv
2133: where prrv.input_value_id = inv.input_value_id
2134: and inv.name = 'Tax Code'

Line 3084: FROM pay_element_types_f

3080: --
3081: -- Get IDs for seed data
3082: SELECT element_type_id
3083: INTO g_paye_details_id
3084: FROM pay_element_types_f
3085: WHERE element_name = 'PAYE Details'
3086: AND l_effective_date BETWEEN effective_start_date
3087: AND effective_end_date;
3088: --

Line 3283: FROM pay_element_types_f

3279: AND pact.date_earned BETWEEN ptp.start_date AND ptp.end_date;
3280: --
3281: CURSOR csr_paye_element IS
3282: SELECT element_type_id
3283: FROM pay_element_types_f
3284: WHERE element_name = 'PAYE';
3285: --
3286: CURSOR csr_input_value(p_ipv_name IN VARCHAR2) IS
3287: SELECT input_value_id