APPS.HR_NZBAL dependencies on PER_ASSIGNMENTS_F

Line 123: , per_assignments_f paf

119: IS
120: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
121: FROM pay_assignment_actions paa
122: , pay_payroll_actions ppa
123: , per_assignments_f paf
124: , pay_payrolls_f ppf
125: , per_time_periods ptp
126: WHERE paf.assignment_id = c_assignment_id
127: AND paf.assignment_id = paa.assignment_id

Line 635: , per_assignments_f paf

631: IS
632: SELECT to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
633: FROM pay_assignment_actions paa
634: , pay_payroll_actions ppa
635: , per_assignments_f paf
636: , pay_payrolls_f ppf
637: , per_time_periods ptp
638: WHERE paf.assignment_id = c_assignment_id
639: AND paf.assignment_id = paa.assignment_id

Line 665: , per_assignments_f paf

661: IS
662: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
663: FROM pay_assignment_actions paa
664: , pay_payroll_actions ppa
665: , per_assignments_f paf
666: , pay_payrolls_f ppf
667: , per_time_periods ptp
668: WHERE paf.assignment_id = c_assignment_id
669: AND paf.assignment_id = paa.assignment_id

Line 939: from per_assignments_f

935: is
936: --
937: cursor csr_business_group(p_assignment_id number) is
938: select business_group_id
939: from per_assignments_f
940: where assignment_id = p_assignment_id;
941: --
942: l_assignment_action_id number;
943: l_balance number;

Line 947: l_business_group_id per_assignments_f.business_group_id%type;

943: l_balance number;
944: l_end_date date;
945: l_action_eff_date date;
946: l_start_dd_mm varchar2(9);
947: l_business_group_id per_assignments_f.business_group_id%type;
948: --
949: begin
950: --
951: l_assignment_action_id := get_latest_action_id( p_assignment_id

Line 1104: from per_assignments_f

1100: is
1101: --
1102: cursor csr_business_group(p_assignment_id number) is
1103: select business_group_id
1104: from per_assignments_f
1105: where assignment_id = p_assignment_id;
1106: --
1107: l_assignment_action_id number;
1108: l_balance number;

Line 1111: l_business_group_id per_assignments_f.business_group_id%type;

1107: l_assignment_action_id number;
1108: l_balance number;
1109: l_end_date date;
1110: l_action_eff_date date;
1111: l_business_group_id per_assignments_f.business_group_id%type;
1112: --
1113: begin
1114: --
1115: l_assignment_action_id := get_latest_action_id( p_assignment_id