APPS.PAY_DK_EHOL_CARD_REQUEST dependencies on PAY_PAYROLLS_F

Line 680: FROM pay_payrolls_f ppf,

676: paf.assignment_id assg_id ,
677: scl.SEGMENT10 def_wrk_patt ,
678: ppf.payroll_id payroll_id ,
679: ppf.PRL_INFORMATION1 holiday_card
680: FROM pay_payrolls_f ppf,
681: per_assignments_f paf,
682: hr_organization_units hou,
683: hr_organization_information hoi,
684: hr_soft_coding_keyflex scl ,

Line 740: FROM pay_payrolls_f ppf

736: name_is_null EXCEPTION;
737:
738: CURSOR get_value_from_ddf(p_effective_date date, p_payroll_id number) IS
739: SELECT ppf.PRL_INFORMATION1
740: FROM pay_payrolls_f ppf
741: WHERE PAYROLL_id = p_payroll_id
742: AND p_effective_date BETWEEN ppf.EFFECTIVE_START_DATE AND ppf.EFFECTIVE_END_DATE;
743:
744:

Line 746: p_payroll_id pay_payrolls_f.payroll_id%type ) IS

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
750: AND nvl(pel.PAYROLL_ID,p_payroll_id) = p_payroll_id

Line 793: l_payroll_id pay_payrolls_f.payroll_id%type;

789: AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date;
790:
791: l_use_holiday_card VARCHAR2(10) := 'N';
792: l_uhc_payroll VARCHAR2(10);
793: l_payroll_id pay_payrolls_f.payroll_id%type;
794: l_last_yr VARCHAR2(10);
795: l_curr_entit_yr VARCHAR2(10);
796: l_action_info_id NUMBER;
797: l_ovn NUMBER;