| 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 | Over Ride 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 | Override 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 | | | |
| ATTRIBUTE26 |
$SRS$.PQPEXREP |
N |
N |
N | | select 'TRANSFER_VARVALUE='||to_char(:$FLEX$.PER_NUMBER_12_2) from sys.dual | Override Variance Value Dummy |
| 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 |
[Home] [Help]