APPS.PAY_SG_DEDUCTIONS dependencies on PER_ASSIGNMENTS_F

Line 931: from per_assignments_f pas,

927: is
928: select max(paa.action_sequence),
929: to_number(to_char(ppa.effective_date,'MM')),
930: max(pas.person_id)
931: from per_assignments_f pas,
932: pay_assignment_actions paa,
933: pay_payroll_actions ppa
934: where (pas.person_id, paa.tax_unit_id)
935: IN (select pas1.person_id,

Line 937: from per_assignments_f pas1,

933: pay_payroll_actions ppa
934: where (pas.person_id, paa.tax_unit_id)
935: IN (select pas1.person_id,
936: hsc1.segment1
937: from per_assignments_f pas1,
938: hr_soft_coding_keyflex hsc1
939: where pas1.assignment_id = c_assignment_id
940: and pas1.soft_coding_keyflex_id = hsc1.soft_coding_keyflex_id
941: and c_date_earned between pas1.effective_start_date and pas1.effective_end_date) /* Bug 5298298 */

Line 957: from per_assignments_f pas,

953: is
954: select paa.assignment_action_id,
955: ppa.effective_date,
956: paa.assignment_id
957: from per_assignments_f pas,
958: pay_assignment_actions paa,
959: pay_payroll_actions ppa
960: where pas.person_id = c_person_id /* Bug 5298298 */
961: and paa.assignment_id = pas.assignment_id

Line 994: l_person_id per_assignments_f.person_id%TYPE;

990: --
991: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
992: l_action_sequence pay_assignment_actions.action_sequence%TYPE;
993: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
994: l_person_id per_assignments_f.person_id%TYPE;
995: l_month number;
996: l_effective_date date;
997: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
998: l_defined_bal_id number;

Line 1116: from per_assignments_f pas,

1112: is
1113: select max(paa.action_sequence),
1114: to_number(to_char(ppa.effective_date,'MM')),
1115: max(pas.person_id)
1116: from per_assignments_f pas,
1117: pay_assignment_actions paa,
1118: pay_payroll_actions ppa
1119: where (pas.person_id, paa.tax_unit_id)
1120: IN (select pas1.person_id,

Line 1122: from per_assignments_f pas1,

1118: pay_payroll_actions ppa
1119: where (pas.person_id, paa.tax_unit_id)
1120: IN (select pas1.person_id,
1121: hsc1.segment1
1122: from per_assignments_f pas1,
1123: hr_soft_coding_keyflex hsc1
1124: where pas1.assignment_id = c_assignment_id
1125: and pas1.soft_coding_keyflex_id = hsc1.soft_coding_keyflex_id
1126: and c_date_earned between pas1.effective_start_date and pas1.effective_end_date) /* Bug 5298298 */

Line 1142: from per_assignments_f pas,

1138: is
1139: select paa.assignment_action_id,
1140: ppa.effective_date,
1141: pas.assignment_id
1142: from per_assignments_f pas,
1143: pay_assignment_actions paa,
1144: pay_payroll_actions ppa
1145: where pas.person_id = c_person_id /* Bug 5298298 */
1146: and paa.assignment_id = pas.assignment_id

Line 1179: l_person_id per_assignments_f.person_id%TYPE;

1175: --
1176: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1177: l_action_sequence pay_assignment_actions.action_sequence%TYPE;
1178: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
1179: l_person_id per_assignments_f.person_id%TYPE;
1180: l_month number;
1181: l_effective_date date;
1182: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
1183: l_defined_bal_id number;