APPS.PAY_PPM_BUS dependencies on PAY_ORG_PAY_METHOD_USAGES_F

Line 122: -- pay_org_pay_method_usages_f must have a table SHARE lock on it before

118: -- lasts for part of the assignment duration then the usage end
119: -- date will be the last eligible row. if for the assignment
120: -- duration a usage doesn't exist at all then the previous
121: -- assignment eligible row must be used. Consistency is ensured because
122: -- pay_org_pay_method_usages_f must have a table SHARE lock on it before
123: -- this routine is called.
124: --
125: function return_usage_date
126: return date is

Line 151: from pay_org_pay_method_usages_f popmu

147: l_start_range in date,
148: l_end_range in date) is
149: select min(popmu.effective_start_date),
150: max(popmu.effective_end_date)
151: from pay_org_pay_method_usages_f popmu
152: where popmu.payroll_id = l_payroll_id
153: and popmu.org_payment_method_id = p_org_payment_method_id
154: and popmu.effective_start_date <= l_end_range
155: and popmu.effective_end_date >= l_start_range;