eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_GB_EDI_P46_CAR dependencies on PAY_PAYROLLS_F

Line 7: g_payroll_id pay_payrolls_f.payroll_id%TYPE;

3:
4: g_package CONSTANT VARCHAR2(20):= 'pay_gb_edi_p46_car.';
5:
6: -- Global Variables for Process Parameters
7: g_payroll_id pay_payrolls_f.payroll_id%TYPE;
8: g_start_date DATE;
9: g_end_date DATE;
10: g_business_group_id hr_organization_units.business_group_id%TYPE;
11: g_tax_ref VARCHAR2(20);

Line 212: Pay_payrolls_f ppf

208: p_eff_date IN DATE) IS
209: SELECT flex.segment1 tax_ref
210: FROM hr_soft_coding_keyflex flex,
211: per_assignments_f asg,
212: Pay_payrolls_f ppf
213: WHERE asg.assignment_id = p_assignment_id
214: AND p_eff_date BETWEEN asg.effective_start_date AND asg.effective_end_date
215: AND asg.payroll_id = ppf.payroll_id
216: AND p_eff_date BETWEEN ppf.effective_start_Date and ppf.effective_end_date

Line 558: pay_payrolls_f ppf,

554: min(asg.effective_start_date) asg_min_start_date,
555: max(asg.effective_end_date) asg_max_end_date
556: FROM hr_soft_coding_keyflex flex,
557: per_all_assignments_f asg,
558: pay_payrolls_f ppf,
559: pqp_vehicle_allocations_f va,
560: pqp_vehicle_repository_f vr
561: WHERE asg.person_id BETWEEN stperson AND endperson
562: AND asg.business_group_id = g_business_group_id

Line 1023: pay_payrolls_f ppf,

1019: min(asg.effective_start_date) asg_min_start_date,
1020: max(asg.effective_end_date) asg_max_end_date
1021: FROM hr_soft_coding_keyflex flex,
1022: per_all_assignments_f asg,
1023: pay_payrolls_f ppf,
1024: pqp_vehicle_allocations_f va,
1025: pqp_vehicle_repository_f vr
1026: WHERE asg.person_id BETWEEN stperson AND endperson
1027: AND asg.business_group_id = g_business_group_id

Line 1862: Pay_payrolls_f ppf,

1858: min(asg.effective_start_date) asg_min_start_date,
1859: max(asg.effective_end_date) asg_max_end_date
1860: FROM hr_soft_coding_keyflex flex,
1861: per_all_assignments_f asg,
1862: Pay_payrolls_f ppf,
1863: pay_assignment_actions act
1864: WHERE act.assignment_action_id = p_assactid
1865: AND act.assignment_id = asg.assignment_id
1866: AND asg.payroll_id +0 = nvl(g_payroll_id,asg.payroll_id)

Line 2299: Pay_payrolls_f ppf,

2295: min(asg.effective_start_date) asg_min_start_date,
2296: max(asg.effective_end_date) asg_max_end_date
2297: FROM hr_soft_coding_keyflex flex,
2298: per_all_assignments_f asg,
2299: Pay_payrolls_f ppf,
2300: pay_assignment_actions act
2301: WHERE act.assignment_action_id = p_assactid
2302: AND act.assignment_id = asg.assignment_id
2303: AND asg.payroll_id +0 = nvl(g_payroll_id,asg.payroll_id)