APPS.PAY_KW_MONTHLY_REPORTS dependencies on PER_ASSIGNMENTS_F

Line 412: FROM per_all_assignments_f asg /*per_assignments_f asg*/

408: DECLARE
409: CURSOR csr_get_assacts IS
410: SELECT distinct asg.assignment_id
411: ,paa.assignment_action_id
412: FROM per_all_assignments_f asg /*per_assignments_f asg*/
413: ,pay_assignment_actions paa
414: ,pay_payroll_actions ppa
415: ,hr_soft_coding_keyflex hscl
416: ,per_all_people_f ppf /*per_people_f ppf*/

Line 598: FROM per_assignments_f asg /*per_all_assignments_f asg*/

594: CURSOR csr_get_emp IS
595: SELECT distinct asg.person_id
596: ,paa.assignment_action_id
597: ,hscl.segment2
598: FROM per_assignments_f asg /*per_all_assignments_f asg*/
599: ,pay_assignment_actions paa
600: ,pay_payroll_actions ppa
601: ,hr_soft_coding_keyflex hscl
602: ,per_people_f ppf /*per_all_people_f ppf*/

Line 1008: FROM per_assignments_f asg /*per_all_assignments_f asg*/

1004: SELECT distinct asg.person_id
1005: ,paa.assignment_action_id
1006: ,hscl.segment2
1007: ,asg.assignment_id
1008: FROM per_assignments_f asg /*per_all_assignments_f asg*/
1009: ,pay_assignment_actions paa
1010: ,pay_payroll_actions ppa
1011: ,hr_soft_coding_keyflex hscl
1012: ,per_people_f ppf /*per_all_people_f ppf*/

Line 1643: FROM per_assignments_f asg /*per_all_assignments_f asg*/

1639: CURSOR csr_get_new_emp IS
1640: SELECT distinct asg.person_id
1641: ,paa.assignment_action_id
1642: ,pos.date_start
1643: FROM per_assignments_f asg /*per_all_assignments_f asg*/
1644: ,pay_assignment_actions paa
1645: ,pay_payroll_actions ppa
1646: ,hr_soft_coding_keyflex hscl
1647: ,per_periods_of_service pos

Line 1673: FROM per_assignments_f asg /*per_all_assignments_f asg*/

1669: SELECT distinct asg.person_id
1670: ,paa.assignment_action_id
1671: ,pos.actual_termination_date
1672: ,ppa.date_earned
1673: FROM per_assignments_f asg /*per_all_assignments_f asg*/
1674: ,pay_assignment_actions paa
1675: ,pay_payroll_actions ppa
1676: ,hr_soft_coding_keyflex hscl
1677: ,per_periods_of_service pos

Line 1698: FROM per_assignments_f asg /*per_all_assignments_f asg*/

1694:
1695: /*Cursor for fetching effective date of salary change*/
1696: CURSOR csr_get_salary_date (p_person_id NUMBER) IS
1697: SELECT date_earned, paa.assignment_action_id
1698: FROM per_assignments_f asg /*per_all_assignments_f asg*/
1699: ,pay_assignment_actions paa
1700: ,pay_payroll_actions ppa
1701: ,per_periods_of_service pos
1702: WHERE asg.assignment_id = paa.assignment_id

Line 1719: FROM per_assignments_f asg /*per_all_assignments_f asg*/

1715: CURSOR csr_get_cha_emp IS
1716: SELECT distinct asg.person_id
1717: ,paa.assignment_action_id
1718: ,date_earned
1719: FROM per_assignments_f asg /*per_all_assignments_f asg*/
1720: ,pay_assignment_actions paa
1721: ,pay_payroll_actions ppa
1722: ,hr_soft_coding_keyflex hscl
1723: ,per_periods_of_service pos