APPS.PER_JP_EMPDET_REPORT_PKG dependencies on PAY_PAYROLL_ACTIONS

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

389: END IF;
390: RETURN lt_res_tb;
391: END get_previous_job_history;
392: --
393: PROCEDURE initialize(p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE )
394: --***************************************************************************
395: -- PROCEDURE
396: -- initialize
397: --

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

414: -- initialization_code
415: --*************************************************************************
416: IS
417: --
418: CURSOR lcr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
419: IS
420: SELECT fnd_number.canonical_to_number(pay_core_utils.get_parameter('PACTID',legislative_parameters)) payroll_action_id
421: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASETID',legislative_parameters)) assignment_set_id
422: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id

Line 434: FROM pay_payroll_actions PPA

430: ,pay_core_utils.get_parameter('IMG',legislative_parameters) img_display
431: ,pay_core_utils.get_parameter('S1',legislative_parameters) sort_order_1
432: ,pay_core_utils.get_parameter('S2',legislative_parameters) sort_order_2
433: ,pay_core_utils.get_parameter('S3',legislative_parameters) sort_order_3
434: FROM pay_payroll_actions PPA
435: WHERE PPA.payroll_action_id = p_payroll_action_id;
436: --
437: -- Local Variables
438: lc_procedure VARCHAR2(200);

Line 455: FROM pay_payroll_actions PPA

451: CLOSE lcr_params;
452:
453: SELECT TO_DATE(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD')
454: INTO gr_parameters.effective_date
455: FROM pay_payroll_actions PPA
456: WHERE PPA.payroll_action_id = gr_parameters.payroll_action_id;
457:
458: --
459: IF gb_debug THEN

Line 532: ' pay_payroll_actions pa'||

528: END IF;
529: --
530: p_sqlstr := ' select distinct p.person_id'||
531: ' from per_people_f p,'||
532: ' pay_payroll_actions pa'||
533: ' where pa.payroll_action_id = :payroll_action_id'||
534: ' and p.business_group_id = pa.business_group_id'||
535: ' order by p.person_id ';
536: --

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

830: -- None
831: --************************************************************************
832: AS
833: --
834: CURSOR lcu_assact_r( p_payroll_action_id_arch pay_payroll_actions.payroll_action_id%TYPE
835: , p_business_group_id per_assignments_f.business_group_id%TYPE
836: , p_organization_id per_assignments_f.organization_id%TYPE
837: , p_location_id per_assignments_f.location_id%TYPE
838: , p_include_term_flag VARCHAR2

Line 852: ,pay_payroll_actions PPA

848: ,pay_assignment_actions PAS
849: ,per_jp_empdet_emp_v PJEDV
850: ,per_periods_of_service PPOF
851: ,pay_population_ranges PPR
852: ,pay_payroll_actions PPA
853: WHERE PAA.person_id = PAP.person_id
854: AND PPA.payroll_action_id = PPR.payroll_action_id
855: AND PPA.payroll_action_id = p_payroll_action_id
856: AND PPR.chunk_number = p_chunk

Line 888: CURSOR lcu_assact( p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE

884: OR (PPOF.actual_termination_date > = p_effective_date AND p_effective_date > = PPOF.DATE_START ))
885: )
886: );
887: --
888: CURSOR lcu_assact( p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE
889: , p_business_group_id per_assignments_f.business_group_id%TYPE
890: , p_organization_id per_assignments_f.organization_id%TYPE
891: , p_location_id per_assignments_f.location_id%TYPE
892: , p_include_term_flag VARCHAR2

Line 963: FROM pay_payroll_actions

959: END IF;
960: --
961: SELECT legislative_parameters
962: INTO lc_legislative_parameters
963: FROM pay_payroll_actions
964: WHERE payroll_action_id = p_payroll_action_id;
965: --
966: ln_old_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PACTID',lc_legislative_parameters));
967: ln_ass_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASETID',lc_legislative_parameters));

Line 986: FROM pay_payroll_actions PPA

982: --
983: IF gn_bg_id IS NULL THEN
984: SELECT PPA.business_group_id
985: INTO gn_bg_id
986: FROM pay_payroll_actions PPA
987: WHERE PPA.payroll_action_id = p_payroll_action_id ;
988: END IF ;
989: --
990: IF gr_parameters.organization_id IS NOT NULL THEN

Line 1979: FROM pay_payroll_actions

1975: ln_cur_pact := pay_magtape_generic.get_parameter_value ('TRANSFER_PAYROLL_ACTION_ID' );
1976: --
1977: SELECT legislative_parameters
1978: INTO lc_legislative_parameters
1979: FROM pay_payroll_actions
1980: WHERE payroll_action_id = ln_cur_pact;
1981: --
1982: ln_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PACTID',lc_legislative_parameters));
1983: --