DBA Data[Home] [Help]

APPS.PQP_USTIAA_PKG dependencies on PAY_PAYROLLS_F

Line 515: FROM pay_payrolls_f prl

511: AND pasg.effective_end_date;
512:
513: CURSOR csr_pay_plan_no (p_payroll_id number) IS
514: SELECT prl.prl_information14
515: FROM pay_payrolls_f prl
516: WHERE prl.payroll_id = p_payroll_id
517: AND prl.prl_information_category = 'US'
518: AND p_date BETWEEN prl.effective_start_date
519: AND prl.effective_end_date;

Line 865: pay_payrolls_f prl

861: p_date date) IS
862: SELECT prl.prl_information4,
863: prl.period_type
864: FROM per_all_assignments_f paf,
865: pay_payrolls_f prl
866: WHERE paf.assignment_id = p_asg_id
867: AND prl.payroll_id = paf.payroll_id
868: AND prl.prl_information_category = 'US'
869: AND p_date BETWEEN paf.effective_start_date