APPS.HR_AUBAL dependencies on PER_ASSIGNMENTS_F

Line 129: from per_assignments_f paf

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

Line 1108: from per_assignments_f

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

Line 1116: l_business_group_id per_assignments_f.business_group_id%type;

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

Line 1253: from per_assignments_f

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

Line 1260: l_business_group_id per_assignments_f.business_group_id%type;

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