DBA Data[Home] [Help]

APPS.PAY_SE_WAGES_SALARIES dependencies on HR_SOFT_CODING_KEYFLEX

Line 387: hr_soft_coding_keyflex hsck

383: IS
384: SELECT papf.person_id --,paaf.assignment_id
385: FROM per_all_assignments_f paaf,
386: per_all_people_f papf,
387: hr_soft_coding_keyflex hsck
388: WHERE papf.business_group_id=csr_v_business_group_id -- 3133 --paaf.assignment_id = p_assignment_id
389: AND paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
390: AND papf.person_id=paaf.person_id
391: --AND paaf.primary_flag='Y'

Line 413: hr_soft_coding_keyflex hsck

409: hsck.SEGMENT9 working_percentage,
410: paaf.frequency,
411: paaf.normal_hours
412: FROM per_all_assignments_f paaf,
413: hr_soft_coding_keyflex hsck
414: WHERE paaf.person_id=csr_v_person_id
415: AND paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
416: AND csr_v_effective_date /*'01-jan-2006'*/ BETWEEN paaf.effective_start_date
417: AND paaf.effective_end_date

Line 893: hr_soft_coding_keyflex hsck

889: IS
890: SELECT distinct papf.person_id --,paaf.assignment_id
891: FROM per_all_assignments_f paaf,
892: per_all_people_f papf,
893: hr_soft_coding_keyflex hsck
894: WHERE papf.business_group_id=csr_v_business_group_id -- 3133 --paaf.assignment_id = p_assignment_id
895: AND paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
896: AND papf.person_id=paaf.person_id
897: and papf.person_id between p_start_person and p_end_person

Line 920: hr_soft_coding_keyflex hsck

916: fnd_number.canonical_to_number(hsck.SEGMENT9) working_percentage,
917: paaf.frequency,
918: paaf.normal_hours
919: FROM per_all_assignments_f paaf,
920: hr_soft_coding_keyflex hsck
921: WHERE paaf.person_id=csr_v_person_id
922: AND paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
923: AND csr_v_effective_date /*'01-jan-2006'*/ BETWEEN paaf.effective_start_date
924: AND paaf.effective_end_date

Line 939: hr_soft_coding_keyflex hsck --,

935: paaf.frequency,
936: paaf.normal_hours,
937: paaf.payroll_id
938: FROM per_all_assignments_f paaf,
939: hr_soft_coding_keyflex hsck --,
940: -- per_all_people_f papf
941: WHERE paaf.business_group_id=csr_v_business_group_id
942: -- papf.person_id=paaf.person_id
943: and paaf.person_id between p_start_person and p_end_person