APPS.PAY_BATCH_BALANCEADJ_WRAPPER dependencies on PER_ASSIGNMENTS_F

Line 633: from per_assignments_f paf

629: -- Modified the following query for the Bug: 5079557
630:
631: cursor c_get_payroll_id IS
632: select paf.payroll_id
633: from per_assignments_f paf
634: where paf.assignment_number = p_assignment_id
635: and paf.business_group_id = p_business_group_id
636: and p_effective_date between paf.effective_start_date and paf.effective_end_date;
637:

Line 664: from per_assignments_f paf, pay_payrolls_f ppf, pay_consolidation_sets pcs

660: -- Bug: 5079557
661:
662: cursor c_get_consolidation_set_id IS
663: select pcs.consolidation_set_id
664: from per_assignments_f paf, pay_payrolls_f ppf, pay_consolidation_sets pcs
665: where paf.assignment_number = p_assignment_id
666: and paf.business_group_id = p_business_group_id
667: and sysdate between paf.effective_start_date and paf.effective_end_date
668: and paf.payroll_id = ppf.payroll_id

Line 735: ln_assignment_id per_assignments_f.assignment_id%TYPE;

731:
732:
733: i number;
734:
735: ln_assignment_id per_assignments_f.assignment_id%TYPE;
736: l_inp_id pay_input_values_f.input_value_id%TYPE;
737: l_inp_name pay_input_values_f.name%TYPE;
738: l_inp_ds pay_input_values_f.display_sequence%TYPE;
739: p_concat_segments varchar2(240) default null;

Line 815: ln_old_assignment_id per_assignments_f.assignment_id%TYPE;

811: -- Bug: 5212904 (Issue# 3)
812:
813: l_batch_line_exists varchar2(2);
814: l_user_modified_batch_grp varchar2(2);
815: ln_old_assignment_id per_assignments_f.assignment_id%TYPE;
816: l_old_consolidation_set_id number;
817: l_old_effective_date date;
818: l_old_prepay_flag varchar2(1);
819: l_old_batch_group_status varchar2(10);