APPS.PAY_NL_ANNUAL_SI_FILE dependencies on PAY_PAYROLL_ACTIONS

Line 408: FROM pay_payroll_actions

404: ,pay_core_utils.get_parameter('ORG_HIERARCHY',legislative_parameters)
405: ,pay_core_utils.get_parameter('SI_PROVIDER_ID',legislative_parameters)
406: ,effective_date
407: ,business_group_id
408: FROM pay_payroll_actions
409: WHERE payroll_action_id = p_payroll_action_id;
410: --
411: l_effective_date date;
412: l_proc VARCHAR2(80):= g_package||' get_all_parameters ';

Line 573: ,pay_payroll_actions ppa

569:
570: IF g_error_count=0 THEN
571: sqlstr := 'SELECT DISTINCT person_id
572: FROM per_people_f ppf
573: ,pay_payroll_actions ppa
574: WHERE ppa.payroll_action_id = :payroll_action_id
575: AND ppa.business_group_id = ppf.business_group_id
576: ORDER BY ppf.person_id';
577:

Line 594: ,pay_payroll_actions ppa

590:
591: ELSE
592: sqlstr := 'SELECT DISTINCT person_id
593: FROM per_people_f ppf
594: ,pay_payroll_actions ppa
595: WHERE ppa.payroll_action_id = :payroll_action_id
596: AND 1 = 2
597: AND ppa.business_group_id = ppf.business_group_id
598: ORDER BY ppf.person_id';