APPS.PAY_JP_UITE_REPORT_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 324: PROCEDURE initialize(p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE )

320: END IF;
321: --
322: END get_numbers;
323: --
324: PROCEDURE initialize(p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE )
325: --***************************************************************************
326: -- PROCEDURE
327: -- initialize
328: -- DESCRIPTION

Line 348: CURSOR lcr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)

344: -- action_creation
345: --*************************************************************************
346: IS
347: --
348: CURSOR lcr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
349: IS
350: SELECT pay_core_utils.get_parameter('PAYROLL_ACTION_ID',legislative_parameters) payroll_action_id
351: ,pay_core_utils.get_parameter('ASSETID',legislative_parameters) assignment_set_id
352: ,pay_core_utils.get_parameter('REP_GROUP',legislative_parameters) rep_group

Line 359: FROM pay_payroll_actions PPA

355: ,pay_core_utils.get_parameter('SUB',legislative_parameters) subject_year
356: ,TO_DATE(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') effective_date
357: ,pay_core_utils.get_parameter('PAY_ARCH',legislative_parameters) payroll_arch
358: ,pay_core_utils.get_parameter('SORT1',legislative_parameters) sort_order
359: FROM pay_payroll_actions PPA
360: WHERE PPA.payroll_action_id = p_payroll_action_id;
361: --
362: -- Local Variables
363: lc_procedure VARCHAR2(200);

Line 550: FROM pay_payroll_actions

546: ln_cur_pact := pay_magtape_generic.get_parameter_value ('TRANSFER_PAYROLL_ACTION_ID' );
547: --
548: SELECT legislative_parameters
549: INTO lc_legislative_parameters
550: FROM pay_payroll_actions
551: WHERE payroll_action_id = ln_cur_pact;
552: --
553: ln_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAY_ARCH',lc_legislative_parameters));
554:

Line 640: ' pay_payroll_actions pa'||

636: END IF;
637: --
638: p_sqlstr := ' select distinct p.person_id'||
639: ' from per_people_f p,'||
640: ' pay_payroll_actions pa'||
641: ' where pa.payroll_action_id = :payroll_action_id'||
642: ' and p.business_group_id = pa.business_group_id'||
643: ' order by p.person_id ';
644: --

Line 687: CURSOR lcu_assact_r( p_payroll_action_id_arch pay_payroll_actions.payroll_action_id%TYPE

683: -- CALLED BY
684: -- None
685: --************************************************************************
686: AS
687: CURSOR lcu_assact_r( p_payroll_action_id_arch pay_payroll_actions.payroll_action_id%TYPE
688: , p_business_group_id per_assignments_f.business_group_id%TYPE
689: )
690: IS
691: SELECT DISTINCT PJUIEV.assignment_id

Line 699: ,pay_payroll_actions PPA

695: ,pay_assignment_actions PAS
696: ,pay_jp_uite_emp_v PJUIEV
697: ,per_periods_of_service PPOF
698: ,pay_population_ranges PPR
699: ,pay_payroll_actions PPA
700: ,hr_all_organization_units HAOU
701: WHERE PAA.person_id = PAP.person_id
702: AND PPA.payroll_action_id = PPR.payroll_action_id
703: AND PPR.person_id = PAP.person_id

Line 720: CURSOR lcu_assact( p_payroll_action_id_arch pay_payroll_actions.payroll_action_id%TYPE

716: AND PAA.effective_end_date; -- Bug 9728577
717:
718:
719: --
720: CURSOR lcu_assact( p_payroll_action_id_arch pay_payroll_actions.payroll_action_id%TYPE
721: , p_business_group_id per_assignments_f.business_group_id%TYPE
722: )
723: IS
724: SELECT DISTINCT PJUIEV.assignment_id

Line 765: FROM pay_payroll_actions

761: END IF;
762: --
763: SELECT legislative_parameters
764: INTO lc_legislative_parameters
765: FROM pay_payroll_actions
766: WHERE payroll_action_id = p_payroll_action_id;
767: --
768: ln_old_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAY_ARCH',lc_legislative_parameters));
769: ln_ass_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSETID',lc_legislative_parameters));