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 890: pay_payrolls_f prl

886: p_date date) IS
887: SELECT prl.prl_information4,
888: prl.period_type
889: FROM per_all_assignments_f paf,
890: pay_payrolls_f prl
891: WHERE paf.assignment_id = p_asg_id
892: AND prl.payroll_id = paf.payroll_id
893: AND prl.prl_information_category = 'US'
894: AND p_date BETWEEN paf.effective_start_date