DBA Data[Home] [Help]

APPS.PAY_DK_EHOL_CARD_REQUEST dependencies on HR_SOFT_CODING_KEYFLEX

Line 684: hr_soft_coding_keyflex scl ,

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 ,
685: per_people_f papf
686: WHERE hou.business_group_id = p_business_group_id
687: AND hou.organization_id = g_legal_employer_id
688: AND hou.organization_id = hoi.organization_id

Line 722: l_5d_6d hr_soft_coding_keyflex.SEGMENT10%type;

718: AND hoi2.ORG_INFORMATION_CONTEXT='DK_HOLIDAY_ENTITLEMENT_INFO'
719: AND hoi2.organization_id = hoi1.organization_id
720: AND p_effective_date BETWEEN hou.DATE_FROM AND nvl(hou.DATE_TO, p_effective_date);
721:
722: l_5d_6d hr_soft_coding_keyflex.SEGMENT10%type;
723: l_work_pattern HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%type;
724: l_ass_no per_assignments_f.ASSIGNMENT_NUMBER%TYPE;
725: l_cvr_no per_people_f.NATIONAL_IDENTIFIER%TYPE;
726: l_flag number;