APPS.PAY_FI_GENERAL dependencies on PAY_PAYROLLS

Line 141: FROM PAY_PAYROLLS PP

137: AND FF.FORMULA_NAME=eev1.SCREEN_ENTRY_VALUE;
138:
139:
140: /* SELECT PRL_INFORMATION1
141: FROM PAY_PAYROLLS PP
142: WHERE pp.business_group_id +0 = p_business_group_id
143: and pp.payroll_id = p_payroll_id
144: and trunc(p_date_earned) between pp.effective_start_date and nvl(pp.effective_end_date,p_date_earned)
145: and PRL_INFORMATION_CATEGORY = 'FI';

Line 354: FROM PAY_PAYROLLS PP

350: AND FF.FORMULA_NAME=eev1.SCREEN_ENTRY_VALUE;
351:
352:
353: /* SELECT PRL_INFORMATION1
354: FROM PAY_PAYROLLS PP
355: WHERE pp.business_group_id +0 = p_business_group_id
356: and pp.payroll_id = p_payroll_id
357: and trunc(p_date_earned) between pp.effective_start_date and nvl(pp.effective_end_date,p_date_earned)
358: and PRL_INFORMATION_CATEGORY = 'FI';

Line 846: FROM PAY_PAYROLLS PP

842: )
843: return NUMBER is
844: cursor csr_get_formula_id is
845: SELECT PRL_INFORMATION1
846: FROM PAY_PAYROLLS PP
847: WHERE pp.business_group_id +0 = p_business_group_id
848: and pp.payroll_id = p_payroll_id
849: and trunc(p_date_earned) between pp.effective_start_date and nvl(pp.effective_end_date,p_date_earned)
850: and PRL_INFORMATION_CATEGORY = 'FI';