DBA Data[Home] [Help]

APPS.PAY_NL_PAYSLIP_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 845: per_all_assignments_f as1,

841: act.assignment_id assignment_id,
842: act.assignment_action_id run_action_id,
843: act1.assignment_action_id prepaid_action_id
844: FROM pay_payroll_actions ppa,
845: per_all_assignments_f as1,
846: pay_assignment_actions act,
847: pay_payroll_actions appa,
848: pay_action_interlocks pai,
849: pay_assignment_actions act1,

Line 1494: FROM per_all_assignments_f

1490: AND paf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;
1491: --
1492: CURSOR csr_nl_emp_organization IS
1493: SELECT organization_id
1494: FROM per_all_assignments_f
1495: WHERE assignment_id=p_assignment_id
1496: AND p_date_earned BETWEEN effective_start_date
1497: AND effective_end_date;
1498: --

Line 1571: FROM per_all_assignments_f paf

1567: --
1568: --
1569: CURSOR csr_get_regular_working_hrs(p_assignment_id NUMBER) IS
1570: SELECT paf.normal_hours normal_hours
1571: FROM per_all_assignments_f paf
1572: WHERE paf.assignment_id = p_assignment_id
1573: AND p_date_earned BETWEEN paf.effective_start_date
1574: AND paf.effective_end_date;
1575: