APPS.PAY_SG_DEDUCTIONS dependencies on PER_ASSIGNMENTS_F

Line 1108: from per_assignments_f pas,

1104: is
1105: select max(paa.action_sequence),
1106: to_number(to_char(ppa.effective_date,'MM')),
1107: max(pas.person_id)
1108: from per_assignments_f pas,
1109: pay_assignment_actions paa,
1110: pay_payroll_actions ppa
1111: where (pas.person_id, paa.tax_unit_id)
1112: IN (select pas1.person_id,

Line 1114: from per_assignments_f pas1,

1110: pay_payroll_actions ppa
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 */

Line 1134: from per_assignments_f pas,

1130: is
1131: select paa.assignment_action_id,
1132: ppa.effective_date,
1133: paa.assignment_id
1134: from per_assignments_f pas,
1135: pay_assignment_actions paa,
1136: pay_payroll_actions ppa
1137: where pas.person_id = c_person_id /* Bug 5298298 */
1138: and paa.assignment_id = pas.assignment_id

Line 1171: l_person_id per_assignments_f.person_id%TYPE;

1167: --
1168: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1169: l_action_sequence pay_assignment_actions.action_sequence%TYPE;
1170: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
1171: l_person_id per_assignments_f.person_id%TYPE;
1172: l_month number;
1173: l_effective_date date;
1174: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
1175: l_defined_bal_id number;

Line 1318: from per_assignments_f pas,

1314: is
1315: select max(paa.action_sequence),
1316: to_number(to_char(ppa.effective_date,'MM')),
1317: max(pas.person_id)
1318: from per_assignments_f pas,
1319: pay_assignment_actions paa,
1320: pay_payroll_actions ppa
1321: where (pas.person_id, paa.tax_unit_id)
1322: IN (select pas1.person_id,

Line 1324: from per_assignments_f pas1,

1320: pay_payroll_actions ppa
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 */

Line 1344: from per_assignments_f pas,

1340: is
1341: select paa.assignment_action_id,
1342: ppa.effective_date,
1343: pas.assignment_id
1344: from per_assignments_f pas,
1345: pay_assignment_actions paa,
1346: pay_payroll_actions ppa
1347: where pas.person_id = c_person_id /* Bug 5298298 */
1348: and paa.assignment_id = pas.assignment_id

Line 1381: l_person_id per_assignments_f.person_id%TYPE;

1377: --
1378: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1379: l_action_sequence pay_assignment_actions.action_sequence%TYPE;
1380: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
1381: l_person_id per_assignments_f.person_id%TYPE;
1382: l_month number;
1383: l_effective_date date;
1384: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
1385: l_defined_bal_id number;