APPS.PY_ROLLBACK_PKG dependencies on PER_ALL_PEOPLE_F

Line 28: full_name per_all_people_f.full_name%type,

24: --
25: -- Assignment Action Level Details.
26: assact_id pay_assignment_actions.assignment_action_id%type,
27: assignment_id per_all_assignments_f.assignment_id%type,
28: full_name per_all_people_f.full_name%type,
29: assignment_number per_all_assignments_f.assignment_number%type,
30: payroll_id pay_all_payrolls_f.payroll_id%type,
31: --
32: -- Other information.

Line 1680: v_person_id per_all_people_f.person_id%TYPE;

1676: v_prj_flg_yes_count number;
1677: v_prj_flg_no_count number;
1678: v_prj_flg_x_count number;
1679: v_return_status varchar2(40);
1680: v_person_id per_all_people_f.person_id%TYPE;
1681: v_time_period_id per_time_periods.time_period_id%TYPE;
1682: --
1683: cursor chdact (p_asgact_id in number) is
1684: select paa_chd.assignment_action_id

Line 1689: cursor get_person_id (p_assignment_id in per_all_people_f.person_id%TYPE, p_effective_date in date) is

1685: from pay_assignment_actions paa_chd
1686: where paa_chd.source_action_id = p_asgact_id
1687: order by paa_chd.action_sequence desc;
1688: --
1689: cursor get_person_id (p_assignment_id in per_all_people_f.person_id%TYPE, p_effective_date in date) is
1690: select PERSON_ID
1691: from per_all_assignments_f paaf
1692: where paaf.assignment_id = p_assignment_id
1693: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date;

Line 2023: l_person_id per_all_people_f.person_id%type;

2019: procedure val_assact_rollback(p_info in out nocopy rollback_rec)
2020: is
2021: l_action_sequence pay_assignment_actions.action_sequence%type;
2022: l_action_status pay_assignment_actions.action_status%type;
2023: l_person_id per_all_people_f.person_id%type;
2024: l_sec_status pay_assignment_actions.secondary_status%type;
2025: c_indent varchar2(40);
2026: begin
2027: -- Obtain information about this assignment action which we will

Line 2066: per_all_people_f PEO,

2062: l_person_id,
2063: p_info.full_name,
2064: p_info.assignment_number
2065: from
2066: per_all_people_f PEO,
2067: pay_object_groups POG_PER,
2068: pay_assignment_actions ACT
2069: where ACT.assignment_action_id = p_info.assact_id
2070: and ACT.source_action_id is null

Line 2122: per_all_people_f PEO,

2118: l_person_id,
2119: p_info.full_name,
2120: p_info.assignment_number
2121: from per_all_assignments_f ASS,
2122: per_all_people_f PEO,
2123: pay_assignment_actions ACT
2124: where ACT.assignment_action_id = p_info.assact_id
2125: and ASS.assignment_id = ACT.assignment_id
2126: and PEO.person_id = ASS.person_id

Line 2132: from per_all_people_f PEO2

2128: and ASS.effective_start_date = (select max(ASS2.effective_start_date)
2129: from per_all_assignments_f ASS2
2130: where ASS2.assignment_id = ASS.assignment_id)
2131: and PEO.effective_start_date = (select max(PEO2.effective_start_date)
2132: from per_all_people_f PEO2
2133: where PEO2.person_id = PEO.person_id)
2134: )
2135: or
2136: ((p_info.action_type = 'Z' or p_info.action_type = 'PRU')

Line 2142: from per_all_people_f PEO2

2138: from per_all_assignments_f ASS2
2139: where ASS2.assignment_id = ASS.assignment_id
2140: and ASS2.effective_start_date <= p_info.action_date)
2141: and PEO.effective_start_date = (select max(PEO2.effective_start_date)
2142: from per_all_people_f PEO2
2143: where PEO2.person_id = PEO.person_id
2144: and PEO2.effective_start_date <= p_info.action_date)
2145: )
2146: or

Line 2157: from per_all_people_f PEO2,

2153: and pbl.assignment_id (+) = ASS.assignment_id
2154: and pbl.effective_Date (+) between ASS2.effective_start_date
2155: and ASS2.effective_end_date)
2156: and PEO.effective_start_date = (select max(PEO2.effective_start_date)
2157: from per_all_people_f PEO2,
2158: pay_batch_lines pbl
2159: where PEO2.person_id = PEO.person_id
2160: and PEO2.person_id = ASS.person_id
2161: and pbl.batch_id (+) = p_info.batch_id