APPS.PER_JP_WRKREG_REPORT_PKG dependencies on PAY_PAYROLL_ACTIONS

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

238: END IF;
239: --
240: END print_clob;
241: --
242: PROCEDURE initialize(p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE )
243: --***************************************************************************
244: -- PROCEDURE
245: -- initialize
246: -- DESCRIPTION

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

262: -- action_creation
263: --*************************************************************************
264: IS
265: --
266: CURSOR lcr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
267: IS
268: SELECT fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ACTION_ID',legislative_parameters)) payroll_action_id
269: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASS_SETID',legislative_parameters)) ass_setid
270: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id

Line 281: FROM pay_payroll_actions PPA

277: ,NVL(pay_core_utils.get_parameter('S3',legislative_parameters),'ZZ') sort_order_3
278: ,pay_core_utils.get_parameter('ITE',legislative_parameters) incl_term_emp
279: ,TO_DATE(pay_core_utils.get_parameter('TEDF',legislative_parameters),'YYYY/MM/DD') term_eff_date_from
280: ,TO_DATE(pay_core_utils.get_parameter('TEDT',legislative_parameters),'YYYY/MM/DD') term_eff_date_to
281: FROM pay_payroll_actions PPA
282: WHERE PPA.payroll_action_id = p_payroll_action_id;
283: --
284: -- Local Variables
285: lc_procedure VARCHAR2(200);

Line 303: FROM pay_payroll_actions PPA

299: CLOSE lcr_params;
300: --
301: SELECT TO_DATE(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD')
302: INTO gr_parameters.effective_date
303: FROM pay_payroll_actions PPA
304: WHERE PPA.payroll_action_id = gr_parameters.payroll_action_id;
305: --
306: IF gb_debug THEN
307: hr_utility.set_location('p_payroll_action_id......... = ' || p_payroll_action_id,30);

Line 382: ' pay_payroll_actions pa'||

378: initialize(p_payroll_action_id);
379: --
380: p_sqlstr := ' select distinct p.person_id'||
381: ' from per_people_f p,'||
382: ' pay_payroll_actions pa'||
383: ' where pa.payroll_action_id = :payroll_action_id'||
384: ' and p.business_group_id = pa.business_group_id'||
385: ' order by p.person_id ';
386: g_mag_payroll_action_id:=P_PAYROLL_ACTION_ID;

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

587: -- None
588: --************************************************************************
589: AS
590: --
591: CURSOR lcu_assact_r( p_payroll_action_id_arch pay_payroll_actions.payroll_action_id%TYPE
592: ,p_business_group_id per_assignments_f.business_group_id%TYPE
593: ,p_organization_id per_assignments_f.organization_id%TYPE
594: ,p_location_id per_assignments_f.location_id%TYPE
595: ,p_effective_date DATE

Line 609: ,pay_payroll_actions PPA

605: ,pay_assignment_actions PAS
606: ,per_jp_wrkreg_emp_v PJWREV
607: ,per_periods_of_service PPOF
608: ,pay_population_ranges PPR
609: ,pay_payroll_actions PPA
610: ,hr_all_organization_units HAOU
611: WHERE PAA.person_id = PAP.person_id
612: AND PPA.payroll_action_id = PPR.payroll_action_id
613: AND PPA.payroll_action_id = p_payroll_action_id

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

643: OR (PPOF.actual_termination_date > = p_effective_date AND p_effective_date > = PPOF.DATE_START ))
644: )
645: );
646: --
647: CURSOR lcu_assact( p_payroll_action_id_arch pay_payroll_actions.payroll_action_id%TYPE
648: ,p_business_group_id per_assignments_f.business_group_id%TYPE
649: ,p_organization_id per_assignments_f.organization_id%TYPE
650: ,p_location_id per_assignments_f.location_id%TYPE
651: ,p_effective_date DATE

Line 722: FROM pay_payroll_actions

718: END IF;
719: --
720: SELECT legislative_parameters
721: INTO lc_legislative_parameters
722: FROM pay_payroll_actions
723: WHERE payroll_action_id = p_payroll_action_id;
724: --
725: ln_old_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ACTION_ID',lc_legislative_parameters));
726: ln_ass_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASS_SETID',lc_legislative_parameters));

Line 1667: FROM pay_payroll_actions

1663: ln_cur_pact := pay_magtape_generic.get_parameter_value ('TRANSFER_PAYROLL_ACTION_ID' );
1664: --
1665: SELECT legislative_parameters
1666: INTO lc_legislative_parameters
1667: FROM pay_payroll_actions
1668: WHERE payroll_action_id = ln_cur_pact;
1669: --
1670: ln_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ACTION_ID',lc_legislative_parameters));
1671: --