DBA Data[Home] [Help]

APPS.PAY_US_EMPLOYEE_BALANCES dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 93: p_classification_id in pay_element_classifications.classification_id%TYPE,

89: form as an OUT parameter.
90: ******************************************************************************/
91: PROCEDURE populate_element_info( p_assignment_id in number,
92: p_assignment_action_id in number,
93: p_classification_id in pay_element_classifications.classification_id%TYPE,
94: p_classification_name in pay_element_classifications.classification_name%TYPE,
95: p_session_date in pay_element_types_f.effective_start_date%TYPE,
96: p_action_date in pay_element_types_f.effective_start_date%TYPE,
97: p_pay_start_date in pay_element_types_f.effective_start_date%TYPE,

Line 94: p_classification_name in pay_element_classifications.classification_name%TYPE,

90: ******************************************************************************/
91: PROCEDURE populate_element_info( p_assignment_id in number,
92: p_assignment_action_id in number,
93: p_classification_id in pay_element_classifications.classification_id%TYPE,
94: p_classification_name in pay_element_classifications.classification_name%TYPE,
95: p_session_date in pay_element_types_f.effective_start_date%TYPE,
96: p_action_date in pay_element_types_f.effective_start_date%TYPE,
97: p_pay_start_date in pay_element_types_f.effective_start_date%TYPE,
98: p_tax_unit_id in number,

Line 245: , pay_element_classifications pec

241: p_tax_unit_id,--control.tax_unit_id
242: p_business_group_id ,--ctlglobals.bg_id
243: NULL) YTD_VAL
244: from pay_element_types_f pet
245: , pay_element_classifications pec
246: , pay_defined_balances pdb
247: , pay_bal_attribute_definitions pbad
248: , pay_balance_attributes pba
249: , pay_balance_types pbt

Line 331: , pay_element_classifications pec

327: p_tax_unit_id,--control.tax_unit_id
328: p_business_group_id ,--ctlglobals.bg_id
329: NULL) YTD_VAL
330: from pay_element_types_f pet
331: , pay_element_classifications pec
332: , pay_defined_balances pdb
333: , pay_bal_attribute_definitions pbad
334: , pay_balance_attributes pba
335: , pay_balance_types pbt

Line 501: from pay_element_classifications ec

497: nvl(l_ytd_date,l_date) ,
498: p_tax_unit_id,--control.tax_unit_id
499: p_business_group_id ,--ctlglobals.bg_id
500: NULL) YTD_VAL
501: from pay_element_classifications ec
502: ,pay_element_types_f et
503: ,pay_element_links_f el
504: ,pay_element_entries_f ee
505: ,pay_element_entry_values_f eev

Line 508: ,pay_element_classifications pec

504: ,pay_element_entries_f ee
505: ,pay_element_entry_values_f eev
506: ,pay_balance_feeds_f pbf
507: ,pay_element_types_f pet2
508: ,pay_element_classifications pec
509: ,pay_input_values_f piv
510: ,pay_balance_types pbt
511: where ec.classification_name = 'Balance Initialization'
512: and ec.legislation_code is null