APPS.PAY_JP_IWHT_REPORT_PKG dependencies on PAY_PAYROLL_ACTIONS

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

347: END get_values;
348:
349:
350: --
351: PROCEDURE initialize(p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE )
352: --***************************************************************************
353: -- PROCEDURE
354: -- initialize
355: -- DESCRIPTION

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

371: -- action_creation
372: --*************************************************************************
373: IS
374: --
375: CURSOR lcr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
376: IS
377: SELECT pay_core_utils.get_parameter('REP_GROUP',legislative_parameters) rep_group
378: ,pay_core_utils.get_parameter('REP_CAT',legislative_parameters) rep_cat
379: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id

Line 387: FROM pay_payroll_actions PPA

383: ,pay_core_utils.get_parameter('SORT_ORDER',legislative_parameters) sort_order
384: ,TO_DATE(pay_core_utils.get_parameter('TEDF',legislative_parameters),'YYYY/MM/DD') termination_date_from
385: ,TO_DATE(pay_core_utils.get_parameter('TEDT',legislative_parameters),'YYYY/MM/DD') termination_date_to
386: ,pay_core_utils.get_parameter('ASS_SETID',legislative_parameters) ass_setid
387: FROM pay_payroll_actions PPA
388: WHERE PPA.payroll_action_id = p_payroll_action_id;
389: --
390: -- Local Variables
391: lc_procedure VARCHAR2(200);

Line 580: FROM pay_payroll_actions

576: ln_cur_pact := pay_magtape_generic.get_parameter_value ('TRANSFER_PAYROLL_ACTION_ID' );
577: --
578: SELECT legislative_parameters
579: INTO lc_legislative_parameters
580: FROM pay_payroll_actions
581: WHERE payroll_action_id = ln_cur_pact;
582: --
583:
584:

Line 666: ' pay_payroll_actions pa'||

662: END IF;
663: --
664: p_sqlstr := ' select distinct p.person_id'||
665: ' from per_people_f p,'||
666: ' pay_payroll_actions pa'||
667: ' where pa.payroll_action_id = :payroll_action_id'||
668: ' and p.business_group_id = pa.business_group_id'||
669: ' order by p.person_id ';
670: --

Line 730: ,pay_payroll_actions PPA

726: ,pay_assignment_actions PAS
727: ,pay_jp_iwht_tax_v PJIWTV
728: ,per_periods_of_service PPOF
729: ,pay_population_ranges PPR
730: ,pay_payroll_actions PPA
731: ,hr_all_organization_units HAOU
732: WHERE PAA.person_id = PAP.person_id
733: AND PPA.payroll_action_id = PPR.payroll_action_id
734: AND PPR.person_id = PAP.person_id

Line 804: FROM pay_payroll_actions

800: END IF;
801: --
802: SELECT legislative_parameters
803: INTO lc_legislative_parameters
804: FROM pay_payroll_actions
805: WHERE payroll_action_id = p_payroll_action_id;
806: --
807: ln_ass_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASS_SETID',lc_legislative_parameters));
808: --