DBA Data[Home] [Help]

APPS.PAY_SG_DEDUCTIONS dependencies on HR_SOFT_CODING_KEYFLEX

Line 1115: hr_soft_coding_keyflex hsc1

1111: where (pas.person_id, paa.tax_unit_id)
1112: IN (select pas1.person_id,
1113: hsc1.segment1
1114: from per_assignments_f pas1,
1115: hr_soft_coding_keyflex hsc1
1116: where pas1.assignment_id = c_assignment_id
1117: and pas1.soft_coding_keyflex_id = hsc1.soft_coding_keyflex_id
1118: and c_date_earned between pas1.effective_start_date and pas1.effective_end_date) /* Bug 5298298 */
1119: and pas.assignment_id = paa.assignment_id

Line 1325: hr_soft_coding_keyflex hsc1

1321: where (pas.person_id, paa.tax_unit_id)
1322: IN (select pas1.person_id,
1323: hsc1.segment1
1324: from per_assignments_f pas1,
1325: hr_soft_coding_keyflex hsc1
1326: where pas1.assignment_id = c_assignment_id
1327: and pas1.soft_coding_keyflex_id = hsc1.soft_coding_keyflex_id
1328: and c_date_earned between pas1.effective_start_date and pas1.effective_end_date) /* Bug 5298298 */
1329: and pas.assignment_id = paa.assignment_id