DBA Data[Home] [Help]

APPS.PAY_SE_ABSENCE dependencies on HR_SOFT_CODING_KEYFLEX

Line 64: ,HR_SOFT_CODING_KEYFLEX SCL

60: ,HR_ORGANIZATION_INFORMATION hoi3
61: ,HR_ORGANIZATION_INFORMATION hoi4
62: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
63: FROM PER_ALL_ASSIGNMENTS_F ASG
64: ,HR_SOFT_CODING_KEYFLEX SCL
65: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
66: AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID
67: AND p_effective_date BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE ) X
68: WHERE o1.business_group_id = l_business_group_id

Line 92: ,HR_SOFT_CODING_KEYFLEX SCL

88: ,HR_ORGANIZATION_INFORMATION hoi3
89: ,HR_ORGANIZATION_INFORMATION hoi4
90: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
91: FROM PER_ALL_ASSIGNMENTS_F ASG
92: ,HR_SOFT_CODING_KEYFLEX SCL
93: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
94: AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID
95: AND p_effective_date BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE ) X
96: WHERE o1.business_group_id = l_business_group_id

Line 193: hr_soft_coding_keyflex hsck

189: ,l_hour_sal
190: ,l_employee_category
191: FROM per_all_assignments_f paaf,
192: per_all_people_f papf,
193: hr_soft_coding_keyflex hsck
194: WHERE paaf.assignment_id = p_assignment_id
195: AND paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
196: AND papf.person_id=paaf.person_id
197: AND p_effective_date BETWEEN paaf.effective_start_date

Line 503: hr_soft_coding_keyflex hsck

499: INTO l_person_id ,
500: p_asg_hour_sal
501: FROM per_all_assignments_f paaf,
502: per_all_people_f papf,
503: hr_soft_coding_keyflex hsck
504: WHERE paaf.assignment_id = p_assignment_id
505: AND paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
506: AND papf.person_id=paaf.person_id
507: AND p_effective_date BETWEEN paaf.effective_start_date

Line 1035: hr_soft_coding_keyflex hsck

1031: ,l_normal_time_end
1032: ,p_sex
1033: FROM per_all_assignments_f paaf,
1034: per_all_people_f papf,
1035: hr_soft_coding_keyflex hsck
1036: WHERE paaf.assignment_id = p_assignment_id
1037: AND paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
1038: AND papf.person_id=paaf.person_id
1039: AND p_effective_date BETWEEN paaf.effective_start_date

Line 3430: hr_soft_coding_keyflex hsck

3426: INTO
3427: l_asg_hour_sal
3428: FROM per_all_assignments_f paaf,
3429: per_all_people_f papf,
3430: hr_soft_coding_keyflex hsck
3431: WHERE paaf.assignment_id = p_assignment_id
3432: AND paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
3433: AND papf.person_id=paaf.person_id
3434: AND p_effective_date BETWEEN paaf.effective_start_date