DBA Data[Home] [Help]

APPS.PAY_GTNLOD_PKG dependencies on PAY_BALANCE_TYPES

Line 1448: from pay_balance_types pbt,

1444: cursor csr_er_liab_rbr is
1445: select distinct pec.classification_name classification_name,
1446: pbt.balance_name balance_name,
1447: pet.element_name element_name
1448: from pay_balance_types pbt,
1449: pay_element_types_f pet,
1450: pay_element_classifications pec,
1451: pay_run_balances prb,
1452: pay_defined_balances pdb,

Line 1476: from pay_balance_types pbt,

1472: cursor csr_er_liab is
1473: select distinct pec.classification_name classification_name,
1474: pbt.balance_name balance_name,
1475: pet.element_name element_name
1476: from pay_balance_types pbt,
1477: pay_element_types_f pet,
1478: pay_element_classifications pec,
1479: pay_run_results prr
1480: where pec.classification_name ='Employer Liabilities'

Line 1507: pay_balance_types pbt,

1503: 'select distinct pec.classification_name classification_name,
1504: pbt.balance_name balance_name,
1505: pet.element_name element_name
1506: from
1507: pay_balance_types pbt,
1508: pay_element_types_f pet,
1509: pay_element_classifications pec,'
1510: || l_er_liab_from||
1511: ' where pec.classification_name ='||'''Employer Liabilities'''||

Line 2075: pay_balance_types pbt,

2071: pet.element_name element_name,
2072: pftr.sui_jurisdiction_code jurisdiction_code,
2073: pst.state_name state_name
2074: from
2075: pay_balance_types pbt,
2076: pay_element_types_f pet,
2077: pay_element_classifications pec,
2078: pay_assignment_actions paa,
2079: per_all_assignments_f paf,

Line 2122: pay_balance_types pbt,

2118: pet.element_name element_name,
2119: pftr.sui_jurisdiction_code jurisdiction_code,
2120: pst.state_name state_name
2121: from
2122: pay_balance_types pbt,
2123: pay_element_types_f pet,
2124: pay_element_classifications pec,
2125: pay_assignment_actions paa,
2126: per_all_assignments_f paf,

Line 2170: pay_balance_types pbt,

2166: pet.element_name element_name,
2167: pftr.sui_jurisdiction_code jurisdiction_code,
2168: pst.state_name state_name
2169: from
2170: pay_balance_types pbt,
2171: pay_element_types_f pet,
2172: pay_element_classifications pec,
2173: pay_assignment_actions paa,
2174: per_all_assignments_f paf,