DBA Data[Home] [Help]

APPS.PAY_DK_STATSR_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 684: ,per_all_assignments_f paaf

680: ,scl.SEGMENT17 TIME_OFF_LIEU
681: ,paaf.hourly_salaried_code HOURLY_SALARIED_CODE
682: FROM
683: per_all_people_f papf
684: ,per_all_assignments_f paaf
685: ,pay_payrolls_f ppf
686: ,hr_soft_coding_keyflex scl
687: ,pay_assignment_actions paa
688: ,pay_payroll_actions ppa

Line 727: per_all_assignments_f paaf

723: select
724: paaf.effective_start_date ASG_START_DATE
725: ,paaf.effective_end_date ASG_END_DATE
726: FROM
727: per_all_assignments_f paaf
728: ,hr_soft_coding_keyflex scl
729: where
730: paaf.assignment_id = p_assignment_id1
731: AND paaf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id

Line 858: l_hourly_salaried per_all_assignments_f.hourly_salaried_code%TYPE ;

854: l_old_sal_basis_mkode VARCHAR2(40);
855: l_old_time_off_lieu VARCHAR2(40);
856:
857: l_bal_todate DATE;
858: l_hourly_salaried per_all_assignments_f.hourly_salaried_code%TYPE ;
859: BEGIN
860: hr_utility.trace('Inside the Statistics Report');
861:
862: IF g_debug THEN