[Home] [Help] [Dependency Information]

VIEW: APPS.PAY_PAYROLLS_F

Object Details

Object Name:	PAY_PAYROLLS_F
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PAY.PAY_PAYROLLS_F
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

PAY_PAYROLLS_F is a view based on the table PAY_ALL_PAYROLLS_F. It
lists all of the payrolls visible within the current security profile, except for
default payrolls associated with advanced benefits.

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT PAYROLL_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      DEFAULT_PAYMENT_METHOD_ID
,      BUSINESS_GROUP_ID
,      CONSOLIDATION_SET_ID
,      COST_ALLOCATION_KEYFLEX_ID
,      SUSPENSE_ACCOUNT_KEYFLEX_ID
,      GL_SET_OF_BOOKS_ID
,      SOFT_CODING_KEYFLEX_ID
,      PERIOD_TYPE
,      ORGANIZATION_ID
,      CUT_OFF_DATE_OFFSET
,      DIRECT_DEPOSIT_DATE_OFFSET
,      FIRST_PERIOD_END_DATE
,      NEGATIVE_PAY_ALLOWED_FLAG
,      NUMBER_OF_YEARS
,      PAY_ADVICE_DATE_OFFSET
,      PAY_DATE_OFFSET
,      PAYROLL_NAME
,      WORKLOAD_SHIFTING_LEVEL
,      COMMENT_ID
,      MIDPOINT_OFFSET
,      ARREARS_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      PAYROLL_TYPE
,      PRL_INFORMATION_CATEGORY
,      PRL_INFORMATION1
,      PRL_INFORMATION2
,      PRL_INFORMATION3
,      PRL_INFORMATION4
,      PRL_INFORMATION5
,      PRL_INFORMATION6
,      PRL_INFORMATION7
,      PRL_INFORMATION8
,      PRL_INFORMATION9
,      PRL_INFORMATION10
,      PRL_INFORMATION11
,      PRL_INFORMATION12
,      PRL_INFORMATION13
,      PRL_INFORMATION14
,      PRL_INFORMATION15
,      PRL_INFORMATION16
,      PRL_INFORMATION17
,      PRL_INFORMATION18
,      PRL_INFORMATION19
,      PRL_INFORMATION20
,      PRL_INFORMATION21
,      PRL_INFORMATION22
,      PRL_INFORMATION23
,      PRL_INFORMATION24
,      PRL_INFORMATION25
,      PRL_INFORMATION26
,      PRL_INFORMATION27
,      PRL_INFORMATION28
,      PRL_INFORMATION29
,      PRL_INFORMATION30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      MULTI_ASSIGNMENTS_FLAG
,      PERIOD_RESET_YEARS
,      PAYSLIP_VIEW_DATE_OFFSET
FROM APPS.PAY_PAYROLLS_F;

Dependencies

[top of page]

APPS

HR_GENERAL - show dependent code

HR_SECURITY - show dependent code

PAY_ALL_PAYROLLS_F

APPS

BEN_BATCH_REPORTING - show dependent code

BEN_BATCH_UTILS - show dependent code

BEN_BENACTIV_XMLP_PKG - show dependent code

BEN_BENAUDIT_XMLP_PKG - show dependent code

BEN_BENBOAUD_XMLP_PKG - show dependent code

BEN_BENBOSUM_XMLP_PKG - show dependent code

BEN_BENCLAUD_XMLP_PKG - show dependent code

BEN_BENCLSUM_XMLP_PKG - show dependent code

BEN_BENDEAUD_XMLP_PKG - show dependent code

BEN_BENDESUM_XMLP_PKG - show dependent code

BEN_BENDFAUD_XMLP_PKG - show dependent code

BEN_BENDFSUM_XMLP_PKG - show dependent code

BEN_BENERPER_XMLP_PKG - show dependent code

BEN_BENERRTY_XMLP_PKG - show dependent code

BEN_BENERTYP_XMLP_PKG - show dependent code

BEN_BENGELOG_XMLP_PKG - show dependent code

BEN_BENPRDEA_XMLP_PKG - show dependent code

BEN_BENPRSUM_XMLP_PKG - show dependent code

BEN_BENUAAUD_XMLP_PKG - show dependent code

BEN_BENUASUM_XMLP_PKG - show dependent code

BEN_CNTPT_EE_VALUE_AND_NAME_V

BEN_DETERMINE_RATE_CHG - show dependent code

BEN_DISTRIBUTE_RATES - show dependent code

BEN_EE_VALUE_AND_NAME_V

BEN_ELECTION_INFORMATION - show dependent code

BEN_ELEMENT_ENTRY - show dependent code

BEN_EXT_PERSON - show dependent code

BEN_EXT_THREAD - show dependent code

BEN_MANAGE_DEFAULT_ENRT - show dependent code

BEN_MANAGE_OPEN_ENRT_WNDW - show dependent code

BEN_PURGE_BCKDT_VOIDED - show dependent code

BEN_TCS_COMPENSATION - show dependent code

GHR_BEN_VALIDATION - show dependent code

GHR_FORMULA_FUNCTIONS - show dependent code

GHR_NON_SF52_EXTRA_INFO - show dependent code

GHR_PAR_EXTRA_INFO_API - show dependent code

GHR_SF52_DO_UPDATE - show dependent code

HRBALDTM - show dependent code

HRENTMNT - show dependent code

HRFV_SALARY_PRO

HRIFV_SAL_PRO

HRI_CL_PAYROLL_HN_V

HRI_OLTP_DISC_SALARY - show dependent code

HRI_PARAMETERS - show dependent code

HR_ADP_ACCRUAL_PLAN_V

HR_ADP_EMP_REF_V

HR_AU_HOLIDAYS - show dependent code

HR_CA_FF_UDFS - show dependent code

HR_CERIDIAN_500_ASSIGNMENT_V

HR_CHANGE_START_DATE_API - show dependent code

HR_DATE_CHK - show dependent code

HR_DELETE - show dependent code

HR_ELEMENTS - show dependent code

HR_GBNIDIR - show dependent code

HR_GB_PROCESS_P11D_ENTRIES_PKG - show dependent code

HR_NL_EXTRA_ASG_RULES - show dependent code

HR_NL_EXTRA_ASG_RULES - show dependent code

HR_NO_UTILITY - show dependent code

HR_NO_UTILITY - show dependent code

HR_NZBAL - show dependent code

HR_NZ_HOLIDAYS - show dependent code

HR_ORG_PRE_DELETE - show dependent code

HR_PAYMENTS - show dependent code

HR_PAY_INTERFACE_ELE_ENT_1_V

HR_PAY_INTERFACE_ELE_ENT_2_V

HR_PAY_INTERFACE_ELE_ENT_3_V

HR_PAY_INTERFACE_ELE_ENT_4_V

HR_PAY_INTERFACE_ELE_ENT_5_V

HR_PERSON_RECORD - show dependent code

HR_PERSON_RECORD - show dependent code

HR_PPVOL - show dependent code

HR_PSF_BUS - show dependent code

HR_PUMP_GET - show dependent code

HR_REPORTS - show dependent code

HR_RUNGEN - show dependent code

HR_SECURITY_INTERNAL - show dependent code

HR_USER_ACCT_INTERNAL - show dependent code

HR_US_FF_UDF1 - show dependent code

HR_US_FF_UDFS - show dependent code

HXC_HXCMISTC_XMLP_PKG - show dependent code

HXC_RESOURCE_RULES_PERSON_V

HXC_RESOURCE_RULES_V

HXTFV_TIMECARDS

HXT_ERRORS_V

HXT_HXT007A_XMLP_PKG - show dependent code

HXT_HXT959A_XMLP_PKG - show dependent code

HXT_HXT964A_XMLP_PKG - show dependent code

HXT_HXT970A_XMLP_PKG - show dependent code

HXT_TIMECARDS_FMV

HXT_TIM_SUMMARY_FMV

PAYBV_ASG_RUN_BALANCE_V

PAYBV_CHECK_PAYMENTS

PAYBV_ELEMENT_ENTRY_DET

PAYBV_ELEMENT_LINK_DETAIL_V

PAYBV_PAYROLL

PAYBV_PAYROLL_ACT_RR_DETAILS

PAYBV_PAYROLL_ACT_RR_EMP_DET

PAYBV_PAYROLL_ACT_RR_ENET_DET

PAYBV_PAYROLL_MESSAGE_V

PAYBV_RETRO_ELEMENT_ENTRIES

PAYBV_RETRO_ELEM_ENTRY_SLADM

PAYLV_PAYROLL_H_V

PAY_AC_ACTION_ARCH - show dependent code

PAY_ADVANCE_PAY_PKG - show dependent code

PAY_AE_ARCHIVE - show dependent code

PAY_AE_RULES - show dependent code

PAY_ALL_PAYROLLS_D

PAY_APAC_PAYSLIP_ARCHIVE - show dependent code

PAY_ARCHIVE_CHEQUEWRITER - show dependent code

PAY_ARCHIVE_MISSING_ASG_PKG - show dependent code

PAY_ASGS_NOT_PROCESSED_V

PAY_ASG_DEBUG_PKG - show dependent code

PAY_AU_EFT - show dependent code

PAY_AU_PAYE_FF - show dependent code

PAY_AU_PAYMENT_SUMMARY - show dependent code

PAY_AU_RECONCILIATION_PKG - show dependent code

PAY_AU_REC_DET_ARCHIVE - show dependent code

PAY_AU_REC_DET_PAYSUM_MODE - show dependent code

PAY_AU_SOE_PKG - show dependent code

PAY_AU_SOE_PKG - show dependent code

PAY_AU_TERMINATIONS - show dependent code

PAY_BATCH_BALANCEADJ_WRAPPER - show dependent code

PAY_CA_ARCHIVE - show dependent code

PAY_CA_WF_PKG - show dependent code

PAY_CNT_BUS - show dependent code

PAY_CN_SOE - show dependent code

PAY_CONSOLIDATION_SETS_PKG - show dependent code

PAY_CORE_FF_UDFS - show dependent code

PAY_CORE_UTILS - show dependent code

PAY_COSTING_DETAILS_V

PAY_COSTING_KFF_UTIL_PKG - show dependent code

PAY_COSTING_SUMMARY_REP_PKG - show dependent code

PAY_COSTING_SUMMARY_X_REP_PKG - show dependent code

PAY_CPT_BUS - show dependent code

PAY_CTY_BUS - show dependent code

PAY_DB_PAY_SETUP - show dependent code

PAY_DIRECT_DEPOSIT_XML - show dependent code

PAY_DK_ARCHIVE - show dependent code

PAY_DK_ARCHIVE_EIN - show dependent code

PAY_DK_MIA_REPORT_PKG - show dependent code

PAY_DK_PAYMENT_PROCESS_PKG - show dependent code

PAY_DK_RULES - show dependent code

PAY_DK_SICKNESS_DP201 - show dependent code

PAY_DK_SICKNESS_DP202 - show dependent code

PAY_DK_STATSR_PKG - show dependent code

PAY_DYN_TRIGGERS - show dependent code

PAY_ELEMENT_EXTRACT_PKG - show dependent code

PAY_ELEMENT_LINKS_PKG - show dependent code

PAY_ELEMENT_TEMPLATE_USER_INIT - show dependent code

PAY_EMP_ACTION_ARCH - show dependent code

PAY_ES_TWR_CALC_PKG - show dependent code

PAY_FI_ARCHIVE_PSTA - show dependent code

PAY_FI_ARCHIVE_PYSA - show dependent code

PAY_FI_RULES - show dependent code

PAY_FR_DB_PAY_SETUP - show dependent code

PAY_FR_OVERTIME - show dependent code

PAY_GB_BACS_TAPE - show dependent code

PAY_GB_COURT_ORDER_UPGRADE - show dependent code

PAY_GB_EAS_SCOTLAND_FUNCTIONS - show dependent code

PAY_GB_EDI_P46_CAR - show dependent code

PAY_GB_ONLINE_SOE - show dependent code

PAY_GB_P11D_ARCHIVE_SS - show dependent code

PAY_GB_PAYROLL_ACTIONS_PKG - show dependent code

PAY_GB_PAYSLIP_ARCHIVE - show dependent code

PAY_GB_STUDENT_LOANS_PKG - show dependent code

PAY_HK_IR56_ARCHIVE - show dependent code

PAY_HK_PAYSLIP_ARCHIVE - show dependent code

PAY_HK_SOE_PKG - show dependent code

PAY_IE_ARCHIVE_DETAIL_PKG - show dependent code

PAY_IE_BIK_CASH_V

PAY_IE_BIK_COMPANY_VEHICLES_V

PAY_IE_BIK_NON_CASH_V

PAY_IE_BIK_OTHER_BENEFITS_V

PAY_IE_BIK_PREF_LOANS_V

PAY_IE_LEGISLATIVE_ARCHIVE - show dependent code

PAY_IE_PYMT_SUMMARY_RPT_PKG - show dependent code

PAY_IE_TAX_VAL - show dependent code

PAY_IN_FORM_24Q_WEB_ADI_V

PAY_IN_PAYSLIP_ARCHIVE - show dependent code

PAY_IN_SOE_PKG - show dependent code

PAY_IN_TERMINATION_PKG - show dependent code

PAY_IPD_BUS - show dependent code

PAY_JP_MAGTAPE_PACTS_V

PAY_JP_SOE_ASSACTS_V

PAY_JP_ZENGIN_TAPE - show dependent code

PAY_KR_ASG_ACTIONS_V

PAY_KR_PROCESS_NAV_PKG - show dependent code

PAY_KR_SEPL_LIAB_SUMMARY_V

PAY_KR_SEP_LIAB_DETAIL_V

PAY_KW_ARCHIVE - show dependent code

PAY_MX_FF_UDFS - show dependent code

PAY_MX_RULES - show dependent code

PAY_MX_TAX_FUNCTIONS - show dependent code

PAY_MX_UTILITY - show dependent code

PAY_NL_CBS_FILE - show dependent code

PAY_NL_PAYSLIP_ARCHIVE - show dependent code

PAY_NL_TAX_PKG - show dependent code

PAY_NO_PACCR_PKG - show dependent code

PAY_NO_PAYPROC_UTILITY - show dependent code

PAY_NO_PAYSLIP_ARCHIVE - show dependent code

PAY_NO_RULES - show dependent code

PAY_NZ_HOLIDAYS_2003 - show dependent code

PAY_NZ_QES_PKG - show dependent code

PAY_NZ_SSCWT_RATE_ARCHIVE - show dependent code

PAY_P45_PKG - show dependent code

PAY_PAYACT_PKG - show dependent code

PAY_PAYCABPS_XMLP_PKG - show dependent code

PAY_PAYCNSOE_XMLP_PKG - show dependent code

PAY_PAYE_ELEMENT_ENTRIES_V2

PAY_PAYFV_ELEMENT_ENTRIES_PKG - show dependent code

PAY_PAYGBGTN_XMLP_PKG - show dependent code

PAY_PAYGBPAY_XMLP_PKG - show dependent code

PAY_PAYGBRRS_XMLP_PKG - show dependent code

PAY_PAYIEP30_XMLP_PKG - show dependent code

PAY_PAYKRSOE_XMLP_PKG - show dependent code

PAY_PAYMENT_XML_PKG - show dependent code

PAY_PAYMIX_HEADER_INSERT

PAY_PAYRG_PKG - show dependent code

PAY_PAYROLLS

PAY_PAYROLLS_F_PKG - show dependent code

PAY_PAYROLLS_V

PAY_PAYROLLS_X

PAY_PAYROLL_ACTIONS_A_V

PAY_PAYROLL_ACTIONS_V

PAY_PAYROLL_ACTIONS_V6

PAY_PAYROLL_ACTIONS_V7

PAY_PAYROLL_XML_EXTRACT_PKG - show dependent code

PAY_PAYRPANP_XML_PKG - show dependent code

PAY_PAYRPENP_XML_PKG - show dependent code

PAY_PAYUSNAC_XMLP_PKG - show dependent code

PAY_PAYUSTIM_XMLP_PKG - show dependent code

PAY_PAYWSPGL_PAYROLLS

PAY_PAY_BUS - show dependent code

PAY_PGL_PKG - show dependent code

PAY_PPM_BUS - show dependent code

PAY_PYAUAPL_XMLP_PKG - show dependent code

PAY_PYAULLAL_XMLP_PKG - show dependent code

PAY_PYAURECP_XMLP_PKG - show dependent code

PAY_PYIEBIKA_XMLP_PKG - show dependent code

PAY_PYNZSOE_XMLP_PKG - show dependent code

PAY_QPQ_API - show dependent code

PAY_RETRO_NOTIF_PKG - show dependent code

PAY_REVERSE_PAYROLL_V

PAY_SA_ARCHIVE - show dependent code

PAY_SE_PAYSLIP_ARCHIVE - show dependent code

PAY_SE_PAYSLIP_REPORT - show dependent code

PAY_SE_RULES - show dependent code

PAY_SE_SALARY_STRUCTURE_STATS - show dependent code

PAY_SG_CPFLINE - show dependent code

PAY_SG_SOE - show dependent code

PAY_SG_SOE - show dependent code

PAY_SRS_QUARTER_PERIODS_V

PAY_SRS_YEAR_PERIODS_V

PAY_UK_ELE_ENTRIES_PKG - show dependent code

PAY_US_MAGTAPE_REPORTING - show dependent code

PAY_US_NACHA_TAPE - show dependent code

PAY_US_PAYROLL_UTILS - show dependent code

PAY_US_PTO_ACCRUAL - show dependent code

PAY_US_TAXBAL_VIEW_PKG - show dependent code

PAY_US_TAX_BALS_PKG - show dependent code

PAY_US_TAX_WF - show dependent code

PAY_US_W2_WF - show dependent code

PAY_US_W4_WF - show dependent code

PAY_US_XDO_REPORT - show dependent code

PAY_WF_PKG - show dependent code

PAY_YEAR_END_EXTRACT - show dependent code

PAY_ZA_ACB_TAPE - show dependent code

PAY_ZA_CALENDARS_PKG - show dependent code

PAY_ZA_PAYROLL_ACTIONS_V

PAY_ZA_PAYSLIP_ARCHIVE - show dependent code

PER_BF_GEN_DATA_PUMP - show dependent code

PER_DB_PER_ADDITIONAL - show dependent code

PER_HU_ABS_REP_ARCHIVE_PKG - show dependent code

PER_KR_ASSIGNMENTS_V

PER_PERCACEI_XMLP_PKG - show dependent code

PER_PERSON_INFORMATION - show dependent code

PER_RI_CRP_DEFAULT_SETTINGS - show dependent code

PER_VIEWS_PKG - show dependent code

PER_ZA_TIME_PERIODS_V4

PER_ZA_TIME_PERIODS_V5

PQH_COMMITMENT_PKG - show dependent code

PQP_ALIEN_EXPAT_WF_PKG - show dependent code

PQP_ERG_BUS - show dependent code

PQP_EXCP_RPT - show dependent code

PQP_EXPREPLOD_PKG - show dependent code

PQP_HROSS_INTEGRATION - show dependent code

PQP_INI_BAL - show dependent code

PQP_NL_ABP_FUNCTIONS - show dependent code

PQP_NL_PENSION_EXTRACTS - show dependent code

PQP_NL_PENSION_EXTRACTS - show dependent code

PQP_NL_PGGM_FUNCTIONS - show dependent code

PQP_NL_PGGM_PENSION_EXTRACTS - show dependent code

PQP_NL_PGGM_PENSION_EXTRACTS - show dependent code

PQP_PENSION_EXTRACTS - show dependent code

PQP_PENSION_EXTRACTS - show dependent code

PQP_PENSION_FUNCTIONS - show dependent code

PQP_PERASGADD_RIW - show dependent code

PQP_TIAALOD_PKG - show dependent code

PQP_USTIAA_PKG - show dependent code

PQP_US_PENSION_EXTRACTS - show dependent code

PQP_US_PENSION_EXTRACTS - show dependent code

PQP_US_SRS_EXTRACTS - show dependent code

PQP_US_SRS_EXTRACTS - show dependent code

PSP_ARCHIVE_RETRIEVE - show dependent code

PSP_ASSIGNMENTS_V

PSP_CLEARING_ACCOUNT_V

PSP_ENC_CREATE_LINES - show dependent code

PSP_ENC_PAYROLL_ASSIGNMENT_V

PSP_PI_IMPORT_DATA - show dependent code

PSP_PREGEN - show dependent code

PSP_PSPARREP_XMLP_PKG - show dependent code

PSP_PSPENEXR_XMLP_PKG - show dependent code

PSP_ROLLBACK_DIST_LINES - show dependent code

PSP_TEMPLATE_SELECTION - show dependent code

PSP_VALID_NON_ORCL_PKG - show dependent code

PYUSDAR_PKG - show dependent code

PYZAMCRP - show dependent code

PY_ZA_COIDA_PKG - show dependent code

SSP_SSPRPOAR_XMLP_PKG - show dependent code

SSP_SSPRPSSP_XMLP_PKG - show dependent code

PUBLIC

PAY_PAYROLLS_F