DBA Data[Home] [Help]

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 3834: ,p_consolidation_set_id out nocopy pay_consolidation_sets.

3830: ,p_df_effective_date out nocopy pay_payroll_actions.
3831: effective_date%TYPE
3832: ,p_df_date_earned out nocopy pay_payroll_actions.date_earned%TYPE
3833: ,p_period_name out nocopy per_time_periods.period_name%TYPE
3834: ,p_consolidation_set_id out nocopy pay_consolidation_sets.
3835: consolidation_set_id%TYPE
3836: ,p_consolidation_set_name out nocopy pay_consolidation_sets.
3837: consolidation_set_name%TYPE
3838: ,p_unprocessed_status out nocopy varchar2

Line 3836: ,p_consolidation_set_name out nocopy pay_consolidation_sets.

3832: ,p_df_date_earned out nocopy pay_payroll_actions.date_earned%TYPE
3833: ,p_period_name out nocopy per_time_periods.period_name%TYPE
3834: ,p_consolidation_set_id out nocopy pay_consolidation_sets.
3835: consolidation_set_id%TYPE
3836: ,p_consolidation_set_name out nocopy pay_consolidation_sets.
3837: consolidation_set_name%TYPE
3838: ,p_unprocessed_status out nocopy varchar2
3839: ,p_mark_for_retry_status out nocopy varchar2
3840: ,p_complete_status out nocopy varchar2

Line 3871: , pay_consolidation_sets con

3867: , hr_general.decode_lookup('ASSIGNMENT_ACTION_STATUS', 'E')
3868: , hr_general.decode_lookup('ACTION_TYPE', 'Q')
3869: from per_assignments_f asg
3870: , pay_payrolls_f pro
3871: , pay_consolidation_sets con
3872: , per_business_groups_perf bus
3873: where /* Assignment's Payroll details */
3874: asg.assignment_id = p_assignment_id
3875: and v_cur_date between asg.effective_start_date