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 1944: l_person_id per_all_people_f.person_id%type;

1940: procedure val_assact_rollback(p_info in out nocopy rollback_rec)
1941: is
1942: l_action_sequence pay_assignment_actions.action_sequence%type;
1943: l_action_status pay_assignment_actions.action_status%type;
1944: l_person_id per_all_people_f.person_id%type;
1945: l_sec_status pay_assignment_actions.secondary_status%type;
1946: c_indent varchar2(40);
1947: begin
1948: -- Obtain information about this assignment action which we will

Line 1987: per_all_people_f PEO,

1983: l_person_id,
1984: p_info.full_name,
1985: p_info.assignment_number
1986: from
1987: per_all_people_f PEO,
1988: pay_object_groups POG_PER,
1989: pay_assignment_actions ACT
1990: where ACT.assignment_action_id = p_info.assact_id
1991: and ACT.source_action_id is null

Line 2043: per_all_people_f PEO,

2039: l_person_id,
2040: p_info.full_name,
2041: p_info.assignment_number
2042: from per_all_assignments_f ASS,
2043: per_all_people_f PEO,
2044: pay_assignment_actions ACT
2045: where ACT.assignment_action_id = p_info.assact_id
2046: and ASS.assignment_id = ACT.assignment_id
2047: and PEO.person_id = ASS.person_id

Line 2053: from per_all_people_f PEO2

2049: and ASS.effective_start_date = (select max(ASS2.effective_start_date)
2050: from per_all_assignments_f ASS2
2051: where ASS2.assignment_id = ASS.assignment_id)
2052: and PEO.effective_start_date = (select max(PEO2.effective_start_date)
2053: from per_all_people_f PEO2
2054: where PEO2.person_id = PEO.person_id)
2055: )
2056: or
2057: ((p_info.action_type = 'Z' or p_info.action_type = 'PRU')

Line 2063: from per_all_people_f PEO2

2059: from per_all_assignments_f ASS2
2060: where ASS2.assignment_id = ASS.assignment_id
2061: and ASS2.effective_start_date <= p_info.action_date)
2062: and PEO.effective_start_date = (select max(PEO2.effective_start_date)
2063: from per_all_people_f PEO2
2064: where PEO2.person_id = PEO.person_id
2065: and PEO2.effective_start_date <= p_info.action_date)
2066: )
2067: or

Line 2078: from per_all_people_f PEO2,

2074: and pbl.assignment_id (+) = ASS.assignment_id
2075: and pbl.effective_Date (+) between ASS2.effective_start_date
2076: and ASS2.effective_end_date)
2077: and PEO.effective_start_date = (select max(PEO2.effective_start_date)
2078: from per_all_people_f PEO2,
2079: pay_batch_lines pbl
2080: where PEO2.person_id = PEO.person_id
2081: and PEO2.person_id = ASS.person_id
2082: and pbl.batch_id (+) = p_info.batch_id