DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on PAY_COST_ALLOCATION_KEYFLEX

Line 850: pay_cost_allocation_keyflex k,

846: g_payroll_consolidation_set,
847: g_payroll_consolidation_set_id
848: from pay_payrolls_f pay,
849: per_time_periods tmpr,
850: pay_cost_allocation_keyflex k,
851: pay_consolidation_sets c
852: where pay.payroll_id = p_payroll_id
853: and p_effective_date between
854: nvl(pay.effective_start_date, p_effective_date)

Line 860: and pay.cost_allocation_keyflex_id = k.cost_allocation_keyflex_id (+)

856: and pay.payroll_id = tmpr.payroll_id
857: and pay.period_type = tmpr.period_type
858: and p_effective_date between nvl(tmpr.start_date, p_effective_date)
859: and nvl(tmpr.end_date, p_effective_date)
860: and pay.cost_allocation_keyflex_id = k.cost_allocation_keyflex_id (+)
861: and pay.consolidation_set_id = c.consolidation_set_id;
862:
863:
864: