DBA Data[Home] [Help]

APPS.PAY_NL_SI_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 921: hr_soft_coding_keyflex hs ,

917: SELECT FND_NUMBER.CANONICAL_TO_NUMBER(hs.segment29) segment29 ,
918: pas.effective_start_date effective_start_date,
919: pas.effective_end_date effective_end_date
920: FROM
921: hr_soft_coding_keyflex hs ,
922: per_all_assignments_f pas
923: WHERE
924: pas.assignment_id = p_assignment_id AND
925: hs.soft_coding_keyflex_id = pas.soft_coding_keyflex_id AND

Line 1062: hr_soft_coding_keyflex scl ,

1058: paa.frequency ,
1059: paa.effective_start_date effective_start_date,
1060: paa.effective_end_date effective_end_date
1061: FROM
1062: hr_soft_coding_keyflex scl ,
1063: per_all_assignments_f paa
1064: WHERE
1065: paa.assignment_id = p_assignment_id AND
1066: scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id AND