APPS.PAY_NO_ARCHIVE_RSEA dependencies on PAY_ACTION_INFORMATION

Line 587: FROM pay_action_information

583:
584: IF l_archive = 'Y' THEN
585:
586: SELECT count(*) INTO l_count
587: FROM pay_action_information
588: WHERE action_context_id = p_payroll_action_id
589: AND action_context_type = 'PA'
590: AND action_information_category = 'EMEA REPORT DETAILS'
591: AND action_information1 = 'PYNORSEA';

Line 679: pay_action_information_api.create_action_information (

675: END IF;
676:
677: /* Inserting header details belonging to Employer*/
678:
679: pay_action_information_api.create_action_information (
680: p_action_information_id => l_action_info_id
681: ,p_action_context_id => p_payroll_action_id
682: ,p_action_context_type => 'PA'
683: ,p_object_version_number => l_ovn

Line 727: pay_action_information_api.create_action_information (

723:
724:
725: /* Inserting the selection criteria for generating the report*/
726:
727: pay_action_information_api.create_action_information (
728: p_action_information_id => l_action_info_id
729: ,p_action_context_id => p_payroll_action_id
730: ,p_action_context_type => 'PA'
731: ,p_object_version_number => l_ovn

Line 1066: pay_action_information_api.create_action_information (

1062: l_eo_calc_contribution :=0;
1063:
1064:
1065: /* Inserting Local unit level data related to employer contributions*/
1066: pay_action_information_api.create_action_information (
1067: p_action_information_id => l_action_info_id
1068: ,p_action_context_id => p_payroll_action_id
1069: ,p_action_context_type => 'PA'
1070: ,p_object_version_number => l_ovn