APPS.HR_AUBAL dependencies on PER_ASSIGNMENTS_F

Line 132: , per_assignments_f paf

128: , c_effective_date in date
129: ) is
130: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
131: from pay_assignment_actions paa
132: , per_assignments_f paf
133: , pay_payroll_actions ppa
134: where paa.assignment_id = c_assignment_id
135: and paf.assignment_id = c_assignment_id
136: and paf.assignment_id = paa.assignment_id

Line 1111: from per_assignments_f

1107: is
1108: --
1109: cursor csr_business_group(p_assignment_id number) is
1110: select business_group_id
1111: from per_assignments_f
1112: where assignment_id = p_assignment_id;
1113: --
1114: l_assignment_action_id number;
1115: l_balance number;

Line 1119: l_business_group_id per_assignments_f.business_group_id%type;

1115: l_balance number;
1116: l_end_date date;
1117: l_action_eff_date date;
1118: l_start_dd_mm varchar2(9);
1119: l_business_group_id per_assignments_f.business_group_id%type;
1120: --
1121: begin
1122: --
1123: l_assignment_action_id := get_latest_action_id( p_assignment_id

Line 1256: from per_assignments_f

1252: is
1253: --
1254: cursor csr_business_group(p_assignment_id number) is
1255: select business_group_id
1256: from per_assignments_f
1257: where assignment_id = p_assignment_id;
1258: --
1259: l_assignment_action_id number;
1260: l_balance number;

Line 1263: l_business_group_id per_assignments_f.business_group_id%type;

1259: l_assignment_action_id number;
1260: l_balance number;
1261: l_end_date date;
1262: l_action_eff_date date;
1263: l_business_group_id per_assignments_f.business_group_id%type;
1264: --
1265: begin
1266: --
1267: l_assignment_action_id := get_latest_action_id( p_assignment_id