DBA Data[Home] [Help]

APPS.PAY_SG_IRAS_AMEND_ARCHIVE dependencies on HR_SOFT_CODING_KEYFLEX

Line 2906: hr_soft_coding_keyflex hsc

2902: aei.aei_information10 ee_cpf_interest,
2903: aei.aei_information11 ee_cpf_date
2904: from per_assignments_f ass,
2905: per_assignment_extra_info aei,
2906: hr_soft_coding_keyflex hsc
2907: where ass.person_id = c_person_id
2908: and ass.assignment_id = aei.assignment_id
2909: and ass.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
2910: and hsc.segment1 = c_tax_unit_id

Line 3524: hr_soft_coding_keyflex hsc

3520: c_basis_end date )
3521: is
3522: select 'X'
3523: from per_assignments_f paf,
3524: hr_soft_coding_keyflex hsc
3525: where paf.person_id = c_person_id
3526: and paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3527: and hsc.segment1 = c_tax_unit_id
3528: and paf.primary_flag = 'Y'

Line 3587: hr_soft_coding_keyflex hsc

3583: c_basis_end date )
3584: is
3585: select paf.assignment_id
3586: from per_assignments_f paf,
3587: hr_soft_coding_keyflex hsc
3588: where paf.person_id = c_person_id
3589: and paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3590: and hsc.segment1 = c_tax_unit_id
3591: and paf.primary_flag = 'Y'

Line 3656: hr_soft_coding_keyflex hsc

3652: c_basis_end date )
3653: is
3654: select max(paf.assignment_id)
3655: from per_assignments_f paf,
3656: hr_soft_coding_keyflex hsc
3657: where paf.person_id = c_person_id
3658: and paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
3659: and hsc.segment1 = c_tax_unit_id
3660: and paf.assignment_type = 'E'