APPS.PAY_P45_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 324: g_paye_details_id pay_element_types_f.element_type_id%TYPE;

320: -- Added for P45PT1. Bug 6345375
321: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;
322: g_sex_eid ff_user_entities.user_entity_id%TYPE;
323: -- Seed data IDs
324: g_paye_details_id pay_element_types_f.element_type_id%TYPE;
325: --
326: FUNCTION get_report_request_error RETURN VARCHAR2 IS
327: BEGIN
328: RETURN g_fnd_rep_request_msg;

Line 411: FROM pay_element_types_f pet,

407: --
408: cursor csr_getdate (x_assignment_id NUMBER,
409: x_termination_date DATE) IS
410: SELECT peev.screen_entry_value
411: FROM pay_element_types_f pet,
412: pay_element_links_f pel,
413: pay_element_entries_f pee,
414: pay_input_values_f piv,
415: pay_element_entry_values_f peev

Line 2008: pay_element_types_f type,

2004: c_effective_end_date in date) is
2005: select 1 from dual where exists
2006: (select prrv.result_value
2007: from pay_input_values_f inv,
2008: pay_element_types_f type,
2009: pay_run_results prr,
2010: pay_run_result_values prrv
2011: where prrv.input_value_id = inv.input_value_id
2012: and inv.name = 'Tax Code'

Line 2750: FROM pay_element_types_f

2746: --
2747: -- Get IDs for seed data
2748: SELECT element_type_id
2749: INTO g_paye_details_id
2750: FROM pay_element_types_f
2751: WHERE element_name = 'PAYE Details'
2752: AND l_effective_date BETWEEN effective_start_date
2753: AND effective_end_date;
2754: --

Line 2898: FROM pay_element_types_f

2894: AND pact.date_earned BETWEEN ptp.start_date AND ptp.end_date;
2895: --
2896: CURSOR csr_paye_element IS
2897: SELECT element_type_id
2898: FROM pay_element_types_f
2899: WHERE element_name = 'PAYE';
2900: --
2901: CURSOR csr_input_value(p_ipv_name IN VARCHAR2) IS
2902: SELECT input_value_id