APPS.PAY_QPQ_API dependencies on PAY_CONSOLIDATION_SETS

Line 596: (p_consolidation_set_id in pay_consolidation_sets.consolidation_set_id%TYPE

592: --
593: -- {End Of Comments}
594: --
595: procedure chk_consol_set
596: (p_consolidation_set_id in pay_consolidation_sets.consolidation_set_id%TYPE
597: ,p_business_group_id in pay_consolidation_sets.business_group_id%TYPE
598: ) is
599: --
600: v_exists varchar2(1);

Line 597: ,p_business_group_id in pay_consolidation_sets.business_group_id%TYPE

593: -- {End Of Comments}
594: --
595: procedure chk_consol_set
596: (p_consolidation_set_id in pay_consolidation_sets.consolidation_set_id%TYPE
597: ,p_business_group_id in pay_consolidation_sets.business_group_id%TYPE
598: ) is
599: --
600: v_exists varchar2(1);
601: v_proc varchar2(72) := g_package||'chk_consol_set';

Line 605: from pay_consolidation_sets

601: v_proc varchar2(72) := g_package||'chk_consol_set';
602: --
603: cursor sel_set is
604: select 'Y'
605: from pay_consolidation_sets
606: where consolidation_set_id = p_consolidation_set_id
607: and business_group_id + 0 = p_business_group_id;
608: begin
609: hr_utility.set_location('Entering:'|| v_proc, 5);

Line 3812: ,p_consolidation_set_id out nocopy pay_consolidation_sets.

3808: ,p_df_effective_date out nocopy pay_payroll_actions.
3809: effective_date%TYPE
3810: ,p_df_date_earned out nocopy pay_payroll_actions.date_earned%TYPE
3811: ,p_period_name out nocopy per_time_periods.period_name%TYPE
3812: ,p_consolidation_set_id out nocopy pay_consolidation_sets.
3813: consolidation_set_id%TYPE
3814: ,p_consolidation_set_name out nocopy pay_consolidation_sets.
3815: consolidation_set_name%TYPE
3816: ,p_unprocessed_status out nocopy varchar2

Line 3814: ,p_consolidation_set_name out nocopy pay_consolidation_sets.

3810: ,p_df_date_earned out nocopy pay_payroll_actions.date_earned%TYPE
3811: ,p_period_name out nocopy per_time_periods.period_name%TYPE
3812: ,p_consolidation_set_id out nocopy pay_consolidation_sets.
3813: consolidation_set_id%TYPE
3814: ,p_consolidation_set_name out nocopy pay_consolidation_sets.
3815: consolidation_set_name%TYPE
3816: ,p_unprocessed_status out nocopy varchar2
3817: ,p_mark_for_retry_status out nocopy varchar2
3818: ,p_complete_status out nocopy varchar2

Line 3849: , pay_consolidation_sets con

3845: , hr_general.decode_lookup('ASSIGNMENT_ACTION_STATUS', 'E')
3846: , hr_general.decode_lookup('ACTION_TYPE', 'Q')
3847: from per_assignments_f asg
3848: , pay_payrolls_f pro
3849: , pay_consolidation_sets con
3850: , per_business_groups_perf bus
3851: where /* Assignment's Payroll details */
3852: asg.assignment_id = p_assignment_id
3853: and v_cur_date between asg.effective_start_date