Name |
Descriptive Flex |
Display |
Insert |
Update |
Default Type |
Default Value |
Shared Name |
ATTRIBUTE1 |
$SRS$.PQPEXREP |
N |
N |
N | C | ARCHIVE | Process Name |
ATTRIBUTE10 |
$SRS$.PQPEXREP |
N |
N |
N | | SELECT pbg.legislation_code FROM per_business_groups pbg where pbg.business_group_id=:$PROFILES$.PER_BUSINESS_GROUP_ID | Legislation Code |
ATTRIBUTE11 |
$SRS$.PQPEXREP |
Y |
Y |
Y | S | SELECT 'Exception Report' FROM sys.dual | Select Report or Group |
ATTRIBUTE11 |
$SRS$.PQPEXREP |
Y |
Y |
Y | S | SELECT 'Exception Report' FROM sys.dual | Select Report or Group |
ATTRIBUTE12 |
$SRS$.PQPEXREP |
Y |
Y |
Y | | | Exception Report Name |
ATTRIBUTE12 |
$SRS$.PQPEXREP |
Y |
Y |
Y | | | Exception Report Name |
ATTRIBUTE13 |
$SRS$.PQPEXREP |
N |
N |
N | | select 'TRANSFER_REPORT='||to_char(:$FLEX$.PQP_EXCEPTION_NAME) from sys.dual | Exception report name dummy |
ATTRIBUTE14 |
$SRS$.PQPEXREP |
Y |
Y |
Y | | | Exception Group Name |
ATTRIBUTE14 |
$SRS$.PQPEXREP |
Y |
Y |
Y | | | Exception Group Name |
ATTRIBUTE15 |
$SRS$.PQPEXREP |
N |
N |
N | | select 'TRANSFER_GROUP='||:$FLEX$.PQP_GROUP_NAME from sys.dual | Exception Group Name Dummy |
ATTRIBUTE16 |
$SRS$.PQPEXREP |
Y |
Y |
Y | | select distinct ppf.payroll_name from pay_payrolls_f ppf,pqp_exception_report_groups perg where perg.exception_group_id=:$FLEX$.PQP_GROUP_NAME and ppf.payroll_id=perg.payroll_id | Payroll |
ATTRIBUTE16 |
$SRS$.PQPEXREP |
Y |
Y |
Y | | select distinct ppf.payroll_name from pay_payrolls_f ppf,pqp_exception_report_groups perg where perg.exception_group_id=:$FLEX$.PQP_GROUP_NAME and ppf.payroll_id=perg.payroll_id | Payroll |
ATTRIBUTE17 |
$SRS$.PQPEXREP |
N |
N |
N | | select 'TRANSFER_PAYROLL='||to_char(:$FLEX$.PY_SRS_PAYROLL) from sys.dual | Payroll Dummy |
ATTRIBUTE18 |
$SRS$.PQPEXREP |
Y |
Y |
Y | | select c.consolidation_set_name from pay_consolidation_sets c, pay_payrolls_f p where c.consolidation_set_id = p.consolidation_set_id and p.payroll_id = :$FLEX$.PY_SRS_PAYROLL AND :$FLEX$.PER_DATES BETWEEN fnd_date.date_to_canonical(effective_start_date) and fnd_date.date_to_canonical(p.effective_end_date) | Consolidation Set |
ATTRIBUTE18 |
$SRS$.PQPEXREP |
Y |
Y |
Y | | select c.consolidation_set_name from pay_consolidation_sets c, pay_payrolls_f p where c.consolidation_set_id = p.consolidation_set_id and p.payroll_id = :$FLEX$.PY_SRS_PAYROLL AND :$FLEX$.PER_DATES BETWEEN fnd_date.date_to_canonical(effective_start_date) and fnd_date.date_to_canonical(p.effective_end_date) | Consolidation Set |
ATTRIBUTE19 |
$SRS$.PQPEXREP |
N |
N |
N | | select 'TRANSFER_CONC_SET='||to_char(:$FLEX$.PY_SRS_CONSOLIDATION_SET) from sys.dual | consolidation set Dummy |
ATTRIBUTE2 |
$SRS$.PQPEXREP |
N |
N |
N | C | EXPREP | Report Type |
ATTRIBUTE20 |
$SRS$.PQPEXREP |
N |
N |
N | S | select to_char(sysdate,'HHSSSS') from dual | PPA_FINDER |
ATTRIBUTE20 |
$SRS$.PQPEXREP |
N |
N |
N | S | select to_char(sysdate,'HHSSSS') from dual | PPA_FINDER |
ATTRIBUTE21 |
$SRS$.PQPEXREP |
N |
N |
N | | select 'TRANSFER_PPA_FINDER='||:$FLEX$.PER_CHAR from sys.dual | PPA_FINDER Dummy |
ATTRIBUTE22 |
$SRS$.PQPEXREP |
N |
N |
N | | select 'TRANSFER_DATE='||to_char(:$FLEX$.PER_DATES) from sys.dual | Date Dummy |
ATTRIBUTE23 |
$SRS$.PQPEXREP |
Y |
Y |
Y | | Select hr_general.decode_lookup('PQP_VARIANCE_TYPES',variance_type) from pqp_exception_reports where exception_report_id=:$FLEX$.PQP_EXCEPTION_NAME | Override Variance Type |
ATTRIBUTE23 |
$SRS$.PQPEXREP |
Y |
Y |
Y | | Select hr_general.decode_lookup('PQP_VARIANCE_TYPES',variance_type) from pqp_exception_reports where exception_report_id=:$FLEX$.PQP_EXCEPTION_NAME | Over Ride Variance Type |
ATTRIBUTE24 |
$SRS$.PQPEXREP |
N |
N |
N | | select 'TRANSFER_VARTYPE='||substr(:$FLEX$.PQP_VARIANCE_TYPE ,0,1) from sys.dual | |
ATTRIBUTE24 |
$SRS$.PQPEXREP |
N |
N |
N | | select 'TRANSFER_VARTYPE='||substr(:$FLEX$.PQP_VARIANCE_TYPE ,0,1) from sys.dual | Override Variance Type Dummy |
ATTRIBUTE25 |
$SRS$.PQPEXREP |
Y |
Y |
Y | | | Over Ride Variance Value |
ATTRIBUTE25 |
$SRS$.PQPEXREP |
Y |
Y |
Y | | Select variance_value from pqp_exception_reports where exception_report_id=:$FLEX$.PQP_EXCEPTION_NAME AND :$FLEX$.PQP_CHOICE='Exception Report' | Override Variance Value |
ATTRIBUTE26 |
$SRS$.PQPEXREP |
N |
N |
N | | select 'TRANSFER_VARVALUE='||to_char(:$FLEX$.PER_NUMBER_12_2) from sys.dual | Override Variance Value Dummy |
ATTRIBUTE26 |
$SRS$.PQPEXREP |
N |
N |
N | | | |
ATTRIBUTE27 |
$SRS$.PQPEXREP |
N |
N |
N | | SELECT 'EG' FROM dual where :$FLEX$.PQP_CHOICE:NULL ='Exception Group' | Is Exception Group |
ATTRIBUTE27 |
$SRS$.PQPEXREP |
N |
N |
N | | SELECT 'EG' FROM dual where :$FLEX$.PQP_CHOICE:NULL ='Exception Group' | Is Exception Group |
ATTRIBUTE28 |
$SRS$.PQPEXREP |
N |
N |
N | | SELECT 'ER' FROM dual where :$FLEX$.PQP_CHOICE:NULL ='Exception Report' | Is Exception Report |
ATTRIBUTE28 |
$SRS$.PQPEXREP |
N |
N |
N | | SELECT 'ER' FROM dual where :$FLEX$.PQP_CHOICE:NULL ='Exception Report' | Is Exception Report |
ATTRIBUTE3 |
$SRS$.PQPEXREP |
N |
N |
N | C | DEFAULT | Report Qualifier |
ATTRIBUTE35 |
$SRS$.PQPEXREP |
Y |
Y |
Y | | | Template_Name |
ATTRIBUTE36 |
$SRS$.PQPEXREP |
Y |
Y |
Y | | | Output_Format |
ATTRIBUTE37 |
$SRS$.PQPEXREP |
N |
N |
N | | | OverRide Variance Type Dummy2 |
ATTRIBUTE4 |
$SRS$.PQPEXREP |
N |
N |
N | | SELECT :$FLEX$.PER_DATES FROM sys.dual | Start Date Process |
ATTRIBUTE5 |
$SRS$.PQPEXREP |
Y |
Y |
Y | S | SELECT fnd_date.date_to_displaydate(sysdate) from sys.dual | Effective Date |
ATTRIBUTE5 |
$SRS$.PQPEXREP |
Y |
Y |
Y | | SELECT fnd_date.date_to_displaydate(sysdate) from sys.dual | Effective Date |
ATTRIBUTE6 |
$SRS$.PQPEXREP |
N |
N |
N | C | REPORT | Report Category |
ATTRIBUTE7 |
$SRS$.PQPEXREP |
N |
N |
N | P | PER_BUSINESS_GROUP_ID | Business Group |
ATTRIBUTE7 |
$SRS$.PQPEXREP |
N |
N |
N | P | PER_BUSINESS_GROUP_ID | Business Group |
ATTRIBUTE8 |
$SRS$.PQPEXREP |
N |
N |
N | | | Dummy Filler1 |
ATTRIBUTE9 |
$SRS$.PQPEXREP |
N |
N |
N | | | Dummy Filler2 |