APPS.PAY_DK_EHOL_CARD_REQUEST dependencies on PAY_ELEMENT_TYPES_F

Line 133: ,pay_element_types_f et

129: FROM per_all_assignments_f asg1
130: ,per_all_assignments_f asg2
131: ,per_all_people_f per
132: ,pay_element_links_f el
133: ,pay_element_types_f et
134: ,pay_input_values_f iv1
135: ,pay_element_entries_f ee
136: ,pay_element_entry_values_f eev1
137: WHERE asg1.assignment_id = p_assignment_id

Line 255: FROM pay_element_types_f

251: , p_time_created IN varchar2
252: ) IS
253: CURSOR element_csr IS
254: SELECT element_type_id
255: FROM pay_element_types_f
256: WHERE element_name = 'Holiday Card Payment Request'
257: AND nvl(business_group_id, p_business_group_id) = p_business_group_id
258: AND nvl(legislation_code, 'DK') = 'DK'
259: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;

Line 372: FROM pay_element_types_f

368: , p_over_hours IN NUMBER
369: , p_year varchar2 ) IS
370: CURSOR element_csr IS
371: SELECT element_type_id
372: FROM pay_element_types_f
373: WHERE element_name = 'Override Holiday Duration'
374: AND nvl(business_group_id, p_business_group_id) = p_business_group_id
375: AND nvl(legislation_code, 'DK') = 'DK'
376: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;

Line 745: CURSOR csr_ele_link(p_element_name pay_element_types_f.element_name%type,

741: WHERE PAYROLL_id = p_payroll_id
742: AND p_effective_date BETWEEN ppf.EFFECTIVE_START_DATE AND ppf.EFFECTIVE_END_DATE;
743:
744:
745: CURSOR csr_ele_link(p_element_name pay_element_types_f.element_name%type,
746: p_payroll_id pay_payrolls_f.payroll_id%type ) IS
747: SELECT pel.ELEMENT_LINK_ID
748: FROM pay_element_links_f pel ,pay_element_types_f pet
749: WHERE pel.ELEMENT_TYPE_ID = pet.element_type_id

Line 748: FROM pay_element_links_f pel ,pay_element_types_f pet

744:
745: CURSOR csr_ele_link(p_element_name pay_element_types_f.element_name%type,
746: p_payroll_id pay_payrolls_f.payroll_id%type ) IS
747: SELECT pel.ELEMENT_LINK_ID
748: FROM pay_element_links_f pel ,pay_element_types_f pet
749: WHERE pel.ELEMENT_TYPE_ID = pet.element_type_id
750: AND nvl(pel.PAYROLL_ID,p_payroll_id) = p_payroll_id
751: AND pet.element_name = p_element_name
752: AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date

Line 760: ,pay_element_types_f et

756:
757: CURSOR check_run_id (p_assg_id number, p_run_id VARCHAR2) IS
758: SELECT 1
759: FROM per_all_assignments_f asg1
760: ,pay_element_types_f et
761: ,pay_input_values_f iv1
762: ,pay_element_entries_f ee
763: ,pay_element_entry_values_f eev1
764: WHERE asg1.assignment_id = p_assg_id