DBA Data[Home] [Help]

APPS.PAY_DK_PR_ASG dependencies on PER_ALL_ASSIGNMENTS_F

Line 360: ,per_all_assignments_f paaf

356: (pivf.input_value_id,'_ASG_YTD')
357: ,paa1.assignment_action_id) balance_amount
358: FROM
359: hr_assignment_set_amendments hasa
360: ,per_all_assignments_f paaf
361: ,pay_all_payrolls_f ppf
362: ,pay_assignment_actions paa1
363: ,pay_assignment_actions paa2
364: ,pay_payroll_actions ppa1

Line 473: per_all_assignments_f paaf

469: ,paa1.assignment_action_id) balance_amount
470:
471: FROM
472: -- hr_assignment_set_amendments hasa
473: per_all_assignments_f paaf
474: ,pay_all_payrolls_f ppf
475: ,pay_assignment_actions paa1
476: ,pay_assignment_actions paa2
477: ,pay_payroll_actions ppa1

Line 720: ,per_all_assignments_f paaf

716: ,paaf.assignment_number asg_num
717:
718: FROM
719: per_all_people_f papf
720: ,per_all_assignments_f paaf
721: ,pay_assignment_actions paa
722: ,per_jobs pj
723: ,hr_all_organization_units haou
724: WHERE

Line 807: l_asg_id per_all_assignments_f.assignment_number%TYPE := -999;

803: l_payroll_action_id NUMBER;
804: l_archiver varchar2(150);
805: l_ele_type_id NUMBER:=-999;
806: l_flag NUMBER :=0;
807: l_asg_id per_all_assignments_f.assignment_number%TYPE := -999;
808: l_tot_ele_run NUMBER := 0;
809: l_tot_ele_ytd NUMBER :=0;
810: l_tot_asg_run NUMBER := 0;
811: l_tot_asg_ytd NUMBER :=0;