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.

APPS.PQP_NL_ABP_FUNCTIONS dependencies on PAY_PAYROLLS_F

Line 1832: FROM pay_payrolls_f

1828: SELECT decode(hrl.lookup_code,'W',53,number_per_fiscal_year)
1829: FROM per_time_period_types,hr_lookups hrl
1830: WHERE period_type =
1831: (SELECT period_type
1832: FROM pay_payrolls_f
1833: WHERE payroll_id =
1834: (SELECT payroll_id
1835: FROM per_all_assignments_f
1836: WHERE assignment_id = p_assignment_id

Line 2806: FROM pay_payrolls_f

2802: SELECT decode(hrl.lookup_code,'W',53,number_per_fiscal_year)
2803: FROM per_time_period_types,hr_lookups hrl
2804: WHERE period_type =
2805: (SELECT period_type
2806: FROM pay_payrolls_f
2807: WHERE payroll_id =
2808: (SELECT payroll_id
2809: FROM per_all_assignments_f
2810: WHERE assignment_id = p_assignment_id

Line 4668: pay_payrolls_f ppf

4664: SELECT asg.organization_id
4665: ,asg.payroll_id
4666: ,fnd_number.canonical_to_number(ppf.prl_information1)
4667: FROM per_all_assignments_f asg,
4668: pay_payrolls_f ppf
4669: WHERE asg.assignment_id = p_assignment_id
4670: AND asg.payroll_id = ppf.payroll_id
4671: AND TRUNC(p_date_earned) BETWEEN asg.effective_start_date
4672: AND asg.effective_end_date

Line 4990: pay_payrolls_f ppf

4986: SELECT asg.organization_id
4987: ,asg.payroll_id
4988: ,fnd_number.canonical_to_number(ppf.prl_information1)
4989: FROM per_all_assignments_f asg,
4990: pay_payrolls_f ppf
4991: WHERE asg.assignment_id = p_assignment_id
4992: AND asg.payroll_id = ppf.payroll_id
4993: AND TRUNC(c_date_earned) BETWEEN asg.effective_start_date
4994: AND asg.effective_end_date